Access query - number of days between 2 datese
Hi,
I would like to know, in a query, how can I calculate the numbers of days between 2 dates
Thanks
I would like to know, in a query, how can I calculate the numbers of days between 2 dates
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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?
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?
hi Patrick! ... hence my comment too ;)