View Full Version : Calculate the Number of Days


rlschwerdt
12-06-2001, 08:49 AM
I have two queries that return dates from a single column, i.e. HiDate and LoDate. I need to write another query using those queries to find the number of days between them (HiDate - LoDate). Can anyone help?

Jack Cowley
12-06-2001, 12:06 PM
The DateDiff() function will return the number of days between your two dates. Search help from any code page for more information on this function.