Determine Number of Months between two Dates

[raymanj]

I am trying to create a script that will determine the number of months there are between any two given dates.

[mr_vodka]

Months meaning FULL months?

In other words,

If the start date is: 01/01/2006

and the end date is: 03/30/2006

Does that count as 2 months?

More info on what how you want to achieve the results.

[raymanj]

Months meaning FULL months?

In other words,

If the start date is: 01/01/2006

and the end date is: 03/30/2006

Does that count as 2 months?

More info on what how you want to achieve the results.

Sorry about that, I want to include any months the dates contain.

Example:

01/01/2006

03/30/2006

# of months: 3

01/11/2006

03/05/2007

# of months: 15

[Raybaudi]

(Year ( dateEnd ) - Year ( dateStart )) * 12 + (Month ( dateEnd ) - Month ( dateStart )) + 1

[MetaSys Software]

Make a number field "NumberOfMonths"

Then write the following script steps in your code..

If(Year ( EndDate ) > Year ( StartDate ) )

{

setField(NumberOfMonths) = (12 * ( (Year(EndDate) - Year(StartDate)) - 1) )

+

(12 - ( (Month (StartDate) - 1)) + Month(EndDate) )

}

else

{

setField(NumberOfMonths) = (Month(EndDate)-Month (StartDate)+1)

}

This will work for all the permutations & combinations of StartDate and EndDate.