Skip to main content
Participant
November 3, 2017
해결됨

How do I calculate # of months between 2 dates in Acrobat DC form?

  • November 3, 2017
  • 4 답변들
  • 1832 조회

Hi there,

Admitted JavaScript idiot here.  Need to calculate number of months to 2 decimals between a move in and move out date.

I got it down to the number of days using what's below.

To make it easy, I only need to take the result from this script and divide by 30.

I do not need years.  So a calculation of more than 12 months is fine.

Could someone help??

Thank you!!

// Custom calculate script

(function () {

var sStart = getField("MOVE_IN_DATE_CLIENT").valueAsString;

var sEnd = getField("MOVE_OUT_DATE_CLIENT").valueAsString;

var dStart, dEnd, diff;

if(sStart && sEnd) {

dStart = util.scand("mm/dd/yy", sStart);

dEnd = util.scand("mm/dd/yy", sEnd);

diff = dEnd.getTime() - dStart.getTime();

event.value = Math.floor(diff / 864e5);

} else {

event.value = "";

}

})();

이 주제는 답변이 닫혔습니다.
최고의 답변: try67

Change:

event.value = Math.floor(diff / 864e5);

To:

event.value = Math.floor(diff / 864e5) / 30;

4 답변

Participant
November 3, 2017

I'm ok with assuming a 30 day month for my purposes.  The calculation is general for what we need it for.  How would I divide this result by 30 using my existing script?

try67
Community Expert
try67Community Expert답변
Community Expert
November 3, 2017

Change:

event.value = Math.floor(diff / 864e5);

To:

event.value = Math.floor(diff / 864e5) / 30;

Participant
November 6, 2017

Thank You!

Inspiring
November 3, 2017

One can use the getFullYear(), getMoth() and getDate() methods to get the number of years,  months and the date within the month respectively. With these values one can easily calculate the number or fractional months to use in the unused term calculation even when the dates cross a year boundary and the all months are assumed to have 30 days.

try67
Community Expert
Community Expert
November 3, 2017

Sorry, I meant by 30...

try67
Community Expert
Community Expert
November 3, 2017

Just divide the result by 12...

On Fri, Nov 3, 2017 at 4:47 PM, scotts74312160 <forums_noreply@adobe.com>