Hi Phil, hmmmm. I typed in "difference in dates"...in Help, and got Datedif, which
"Returns a Variant (Long) specifying the number of time intervals between two specified dates."
It also has an example.
Then I went to Microsoft.com and typed in "difference in dates" in the Search box. I got:
What do you want to do?
Calculate the number of days between two dates
Calculate the number of months between two dates
Calculate the number of years between two dates
As you did not state how are you are getting the dates in the first place - and i thought, well, gosh, maybe he is using Date Fields....I typed in "Date Fields" in.....Help.
There is a bunch of stuff there, as well.
With all due respect, you must get exhausted quickly.
Can you even get one date? Can you get two dates? Have you tried using a subtraction operators, as in date1 - date2? Try a few things, and if you still have problems post back with what you have actually tried.
Gerry