Access query - number of days between 2 datese


I would like to know, in a query, how can I calculate the numbers of days between 2 dates

Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

Dale FyeConnect With a Mentor Commented:
You can use the DateDiff() function:

DaysBetween:DateDiff("d", [StartDate], [EndDate])

Note that for consecutive days this will return the value 1.  Basically, this takes the integer portion of the [EndDate] and subtracts the integer portion of [StartDate].
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
adding on: if date also contains a time component, you can test this and subtract one day if time for comparison date is greater than time for the first date since a full day(s) will not have passed.
Patrick MatthewsCommented:
Depends on what you need to know.  For example, as Dale noted, you could use DateDiff, but what that delivers is the number of time period boundaries between two date/time values.

For example, consider these two values:

2016-09-05 23:59:59
2016-09-07 00:00:00

DateDiff using "d" for the interval length, would return two.  In terms of true time elapsed, it's one day plus one second.

So, what specifically are you trying to calculate?
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
hi Patrick! ... hence my comment too ;)
All Courses

From novice to tech pro — start learning today.