Query Date Help

A

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?
 
A

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!!
 
Top