Access Date Range bleeding into another year.
Posted on 2015-01-23
In Access, I have a ArriveDate and LeaveDate, I need to count the dates in the current year. When the ArriveDate is 12/29/15 and the LeaveDate is 1/3/16, I only want it to count the 3 days. I am currently using DateDiff("d",[ArriveDate],[LeaveDate]).. but this doesn't work when the LeaveDate goes into the next year... Additionally, when it is the next year, I need to begin to count the days of the current year.. So if the year is 2016 and the ArriveDate is 12/29/15 and the LeaveDate is 1/3/16- it should count 2 days.