Years and months between 2 dates

  • Thread starter Thread starter Johnathon Anderson
  • Start date Start date
J

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
 
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."
 
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
'====================================================
 
Thank you Al and John for your help.

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