Skip to main content
D
Daniel_12
Participating Frequently
December 16, 2019
Answered

Calculate Months between two Fields

  • December 16, 2019
  • 3 replies
  • 1365 views

Hi there,

 

hope anyone could help here.

 

I have 3 Fields

 

1st Field is the Start Date wich you could pick with a Calender and its Formated in mm/yyyy

2nd Field is the End Date wich you could pick with a Calender and its Formated in mm/yyyy

 

and the 3rd Field is the Field where the Calcualtion should write the Months betweet this two Fields

 

Example:

Begin: 02/2019

End: 05/2020

MonthsTotal: 16

 

The starting and ending Months also count.

 

Begin Field is named begin

End Field is named end

 

 

Thank you

 

Best Regards

Daniel

 

 

This topic has been closed for replies.
Correct answer gkaiseril

I would convert the start and end date vstring values to the number of months and then set the field value to the difference plus 1.

 

event.value = "";
// get input values;
var cBegin = this.getField("begin").valueAsString;
var cEnd = this.getField("end").valueAsString;
// compute only if we have both dates;
if(cBegin != "" && cEnd != "") {
// convert dates values to an array of month and year;
var aBegin = cBegin.split("/");
var aEnd = cEnd.split("/");
// convert years to months and add to months;
var nBeginMonths = Number(aBegin[0]) + (aBegin[1] * 12);
var nEndMonths = Number(aEnd[0]) + (aEnd[1] * 12);
// compute difference and add start month;
var nDiffMonths = nEndMonths - nBeginMonths + 1;
// set field value;
event.value = nDiffMonths;
}

3 replies

D
Daniel_12Author
Participating Frequently
December 17, 2019

Thank you this works like it should 🙂

G
gkaiserilCorrect answer
Inspiring
December 16, 2019

I would convert the start and end date vstring values to the number of months and then set the field value to the difference plus 1.

 

event.value = "";
// get input values;
var cBegin = this.getField("begin").valueAsString;
var cEnd = this.getField("end").valueAsString;
// compute only if we have both dates;
if(cBegin != "" && cEnd != "") {
// convert dates values to an array of month and year;
var aBegin = cBegin.split("/");
var aEnd = cEnd.split("/");
// convert years to months and add to months;
var nBeginMonths = Number(aBegin[0]) + (aBegin[1] * 12);
var nEndMonths = Number(aEnd[0]) + (aEnd[1] * 12);
// compute difference and add start month;
var nDiffMonths = nEndMonths - nBeginMonths + 1;
// set field value;
event.value = nDiffMonths;
}

    bebarth
    Community Expert
    bebarthCommunity Expert
    Community Expert
    December 16, 2019

    Hi,

    Here is my solution. This script must be placed in calcul for the target field:

    var dB=this.getField("begin").valueAsString;
    var nB=dB.indexOf("\/");
    var dE=this.getField("end").valueAsString;
    var nE=dE.indexOf("\/");
    if (dB!="" && dE!="") {
    var mB=Number(dB.substring(0,nB));
    var yB=Number(dB.substring(nB+1));
    var mE=Number(dE.substring(0,nE));
    var yE=Number(dE.substring(nE+1));
    if (yE<yB) {
    var yE=[yB, yB=yE][0];
    var mE=[mB, mB=mE][0];
    }
    var delta= ((yE-yB-1)*12)+(12-mB)+mE+1;
    event.target.value=delta;
    } else {
    event.target.value="";
    }

    You will find an example file at:

    https://wetransfer.com/downloads/6e1106414d4d0779b8979c925839420420191216160548/b6d3cb5dd9e7f872a658514e89160fce20191216160548/706d8d

    @+

     

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