Number of months between two dates

reddyamarnath · Post by **reddyamarnath** » Thu Sep 15, 2011 11:51 am

Hi
can any one please help me how to calculate the number of months between two dates.

Thanks

Etler21 · Post by **Etler21** » Thu Sep 15, 2011 12:36 pm

you can use MonthfromDate() function to get month out and then subtract.

qt_ky · Post by **qt_ky** » Thu Sep 15, 2011 9:28 pm

That may depend on your requirements and definition on month: 28, 29, 30, or 31 days? How many months would you say are between Jan. 31 and Feb. 1? How many between Jan. 31 and Mar. 1? etc.

jwiles · Post by **jwiles** » Thu Sep 15, 2011 11:20 pm

One method that worked for a client several years ago was:

Code: Select all

(Year1 - Year2) * 12 + (Month1 - Month2) + (if Day1 >= Day2 then 1 else 0)

where Date1 is the later of the two dates (Year1, Month1, Day1). That particular client didn't care about the number of days in the month for the calculation. How you extract Year, Month and Day will depend on the format of your dates.

Regards,