View Full Version : Finding number of days between 2 dates


mlamont
11-21-2001, 08:00 AM
I am working on a school project and I have run into some trouble with a query. I need to find out how many days are in between 2 dates ie. Sept 1, 2001 and Sept 3 is 3 days. I am having trouble getting a numerical value. Can anybody help me?

Fizzio
11-21-2001, 08:12 AM
Use DateDiff Function

eg DateDiff("d",[FirstDate],[SecondDate])

Use it in a calculated control box or as an expression in your query