Skip to main content
rachelle_b
rachelle_b
Known Participant
Apr 17, 2019 6:35 AM UTC
Question

Calculation script needed for the number of months between a start date and end date.

The date will be formatted as mm dd yyyy. Thanks for your help and time.

This topic is closed to new replies. Start a new post to keep the conversation going.

6 replies

JR Boulay
Community Expert
JR BoulayCommunity Expert
Community Expert
Apr 17, 2019 9:47 AM UTC

This (free) tool should helps too : http://practicalpdf.com/the-practicalpdf-date-library-for-adobe-acrobat/

Translate
Acrobate du PDF, InDesigner et Photoshopographe
rachelle_b
rachelle_bAuthor
Known Participant
Apr 18, 2019 1:42 AM UTC

Thanks JR.

Translate
    try67
    Community Expert
    try67Community Expert
    Community Expert
    Apr 17, 2019 8:59 AM UTC

    Date calculations are not simple in JavaScript. You can start by reading these tutorials:

    https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript

    https://acrobatusers.com/tutorials/working-with-date-and-time-in-acrobat-javascript-part-2

    https://acrobatusers.com/tutorials/working-date-and-time-acrobat-javascript-part-3-3

    Translate
    rachelle_b
    rachelle_bAuthor
    Known Participant
    Apr 18, 2019 1:41 AM UTC

    Thank you!

    Translate
    rachelle_b
    rachelle_bAuthor
    Known Participant
    Apr 17, 2019 7:01 AM UTC

    Just to clarify, the result should have at least 2 decimals. Here is the existing Excel calculation:

    =DATEDIF(STARTDATE+2-DAY(STARTDATE+1),ENDDATE,"m")-(DAY(STARTDATE +1)-1)/DAY(EOMONTH(STARTDATE +1,0))+DAY(ENDDATE)/DAY(EOMONTH(ENDDATE,0))+0.03

    Translate
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices