How to Calculate days since a date

  • Thread starter Thread starter DawnTreader
  • Start date Start date
D

DawnTreader

hello all

i have need of how to figure out the number of days since a date to a date.
for example, jan 1 2007 to july 25 2007.

i am tracking the year to date of sales and compare it to the same period of
the previous year.

i need the year to be able to "slide". so that next year it would
automattically change to being 2008, the previous year.
 
Take a look at the DateDiff() function ... it calculates the difference
between two dates.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top