Calculating Dates

[Mel Sinkler]

I would like to perform the following DateFunction on a
form: Calculate dates and have results reflected as
follows 38 years, 5 months, 12 days instead of just
either the years, months, or days

Example: =DateDiff("m",[Date1],Now()) results 11 months

Thanks for any help

Mel

 

[Douglas J. Steele]

Take a look at http://members.rogers.com/douglas.j.steele/Diff2Dates.html