Using Dates in Access

C

Christine

Has anyone any idea how in a query I can calculate the difference between todays date and another date and show the answer in days?
 
A

Allen Browne

Enter something like this into the Field row of a query:
Days: DateDiff("d", Date(), [SomeField])

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Christine said:
Has anyone any idea how in a query I can calculate the difference between
Click to expand...
todays date and another date and show the answer in days?
 
Top