Query Date Help

[aldunford]

I need to create a query that will do the following:

these are my fields: resign date, hire date

I need to subtract the resign date from hire date but I want it to return
the answer as years, months & days

ie. 11/7/1986 - 6/18/1979 = 7 years 4 months & 19 days

is there a way to use the DateDiff function to return years, monts & days?

 

[Ofer Cohen]

Look at this link on "A More Complete DateDiff Function"

http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[aldunford]

This worked great thanks so much!! I have one more question.

Now that i have the format I need as 7 years 4 months & 19 days for my prior
service. How can I substract that from new hire date of 11/17/1986 to get
6/28/1979?

I appreciate all your time and help!!