difference between two date in years

  • Thread starter Thread starter ssddteam
  • Start date Start date
S

ssddteam

Can someone tell me how i couldfind the difference between two date in years
and months in access.
one field is named start date and i would like it to give me the years and
months. for example my start date is 11/13/89 i have 16 years 3 months.

Thank you
 
Please do not repost the same question repeatedly in hopes of getting a
"quicker" reply. Folks will respond, and already have... to your original
post.
 
You could use:
DateDiff("m", [Date1], [Date2])
to get the difference in months.

Then use integer division to get the whole number of years, and Mod to get
the left over months:
DateDiff("m", [Date1], [Date2]) \ 12 & " years " & DateDiff("m",
[Date1], [Date2]) Mod 12 & " months"

For a more comprehensive solution, see:
A More Complete DateDiff Function
at:
http://www.accessmvp.com/djsteele/Diff2Dates.html
 
Back
Top