Difference between two dates in Years and Months.

  • Thread starter Thread starter Floyd Forbes
  • Start date Start date
F

Floyd Forbes

I'd like the difference between two dates to be displayed in years and
months.
How do I format the DateDiff function so that I can achieve this?

Appreciate any help!

Floyd
 
Use DateDiff to return the number of months, then change that to years and
months (note that partial months may be incorrectly calculated as full
months using DateDiff):

NumberOfYears = DateDiff("m", StartDate, EndDate) \ 12
NumberOfMonths = DateDiff("m", StartDate, EndDate) - NumberOfYears * 12
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating difference between dates 3
Access 2 Digit year in Access Text Box 3
difference between two date in years 3
Years and Months age calculation? 2
Age, Total months t be displayed 1
Yearly Calendar 3
date difference 6
Calculate age - show months as well 1

Back
Top