Years and months between 2 dates

[Johnathon Anderson]

Is there a query calculation that will display the result of the difference
between 2 dates in Months and Years

eg. 15 Years and 11 Months

Thanks

Johnathon

 

[Al Campagna]

Johnathon,
This is an often asked question, and the Access newsgroups
have many solutions under "Years and Months." Please check that out...

Try... (all in one line)
=DateDiff("m",[Date Of Birth],[Date of Death]) \12 & " years and " &
DateDiff("m",[Date Of Birth],[Date of Death]) Mod 12 & " month/s"

Or...
For a more accurate, and versatile method, check out Doug Steele's
"More Complete DateDiff Function"
http://www.accessmvp.com/djsteele/Diff2Dates.html
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John Spencer]

Try the "More Complete DateDiff Function" Graham Seach and Doug Steele
wrote.

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

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Johnathon Anderson]

Thank you Al and John for your help.

I have used this
A More Complete DateDiff Function
and it is really good.