Re: Substract two dates to get the number of months

[Barbara Morris <bmorris@xxxxxxxxxx>]

On 1/6/2011 9:35 AM, Elbert Cook wrote:
> DateDiff = %diff(Date1 : Date2 : *days) / 30;

It may be better to get the diff in months first, then get the number of 
days left over, and divide that by 30 or probably better 30.5.

   NumMonths = %diff(Date1 : Date2 : *months);
   NumDays = %diff(Date1 : Date2 + %months(%int(NumMonths)) : *days);
   NumMonths += NumDays / 30.5;

It depends what you want the answer to be for say the difference between 
Feb 15 and March 15.  Do you want that to be exactly one month, or do 
you want that to be a partial month?