Report on how many days have elapsed

Mich76

New member
Local time
Today, 18:07
Joined
Mar 10, 2010
Messages
4
How do I word a query to show how many days have elapsed, from the date an item has been logged.


Thanks


Michelle
 
You can use the following calculation in your query:

DaysElapsed: DateDiff("d",[LoggedDate],Date())

Chris
 

Users who are viewing this thread

Back
Top Bottom