G Guest Jan 7, 2004 #1 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?
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 Jan 7, 2004 #2 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?
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?
