Skip to main content
Jerry_Owens4329
Participating Frequently
September 11, 2024
Answered

I need the number of days between two dates in PDF form

Have attempted to generate the number of days between two dates using a custom calculation in a text field form and no matter what formula I use the field blank.

 

Can anyone help?

Nesa Nurani
Nesa NuraniCorrect answer
Community Expert
September 12, 2024

Here you go:

var date1 = this.getField("Date1").valueAsString;
var date2 = this.getField("Date2").valueAsString;

if (date1 && date2) {
 var d1 = new Date(date1);
 var d2 = new Date(date2);

 var year1 = d1.getFullYear();
 var year2 = d2.getFullYear();
 var month1 = d1.getMonth();
 var month2 = d2.getMonth();

 var diffInMonths = (year2 - year1) * 12 + (month2 - month1);

 event.value = diffInMonths;} 
else {
 event.value = "";}
View reply

7 replies

Nesa Nurani
Community Expert
Nesa NuraniCommunity Expert
Community Expert
September 11, 2024

I assume you have two dates fields and want to show number of days in 3rd field, let's say two dates fields are named "Date1" and "Date2", use this as custom calculation script of 3rd field:

 

var date1 = this.getField("Date1").valueAsString;
var date2 = this.getField("Date2").valueAsString;

if (date1 && date2) {
 var d1 = new Date(date1);
 var d2 = new Date(date2);
 var diffInMs = d2.getTime() - d1.getTime();

 var diffInDays = diffInMs / (1000 * 60 * 60 * 24);
  event.value = diffInDays.toFixed(0);} 
else {
 event.value = "";}

 

 

Translate
    Jerry_Owens4329Author
    Participating Frequently
    September 11, 2024

    Perfect it works! 

    Is there a Java script to count months between two dates.

    Translate
    Nesa Nurani
    Community Expert
    Nesa NuraniCommunity ExpertCorrect answer
    Community Expert
    September 12, 2024

    Here you go:

    var date1 = this.getField("Date1").valueAsString;
var date2 = this.getField("Date2").valueAsString;

if (date1 && date2) {
 var d1 = new Date(date1);
 var d2 = new Date(date2);

 var year1 = d1.getFullYear();
 var year2 = d2.getFullYear();
 var month1 = d1.getMonth();
 var month2 = d2.getMonth();

 var diffInMonths = (year2 - year1) * 12 + (month2 - month1);

 event.value = diffInMonths;} 
else {
 event.value = "";}
    Translate
      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices