These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

Not another Date Calc - Months between 2 Dates

2010-07-14 08:01:13

Dan_B

Registered: Jul 14 2010

Posts: 3

Hi All,

I'm trying to build a form as as part of the user input I need the user to provide me with 2 dates:

*Start Date (date{MMMM, YYYY})
*End Date (date{MMMM, YYYY})

The 3rd field needs to calculate the number of months between the 2 dates, simple... Well.. I got it working using the built-in formula Date2Num but I cannot find a way to do the same for Months?.

Help would be appreciated.

Kind Regards
Dan_B

My Product Information:
LiveCycle Designer, Windows

2010-07-14 08:12:43

gkaiseril

Registered: Feb 23 2006

Posts: 4307

Since there is no set number of days in a month, I doubt one could use the number of days from the Epoch date. For that type of calculation, I would look at getting the year value, the numeric month value form the date string. One could then convert the years to months and and the number of months for each date and the compute the difference in months.

George Kaiser