Issue with JavaScript Date

 1 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
tommyg-006
Basic Member Send Private Message
Posts: 11
Basic Member

Good Afternoon All,

I am hoping somebody else has run into this issue before.  I seem to be having with a JavaScript calculation in IPA.  We are trying to take today's date (i.e 10/15/2019) and move it forward to December so the date range starts at 12/01/2019.  However, when the script runs it returns a date of 00/01/2020.  The script works for every other month in the calendar except for 12/1.  Below is the script that we have in IPA:

 

Evaluating JavaScript expression jsDate=CurrentDateTR

 

CurrentFirstofMonth=jsDate.setDate(1); to value 1569960755400

Evaluating JavaScript expression //current date

jsDate = CurrentDateTR;

 

//set forward 3 months

jsDate.setMonth(jsDate.getMonth()+3);

 

//set day to the first

jsDate.setDate(1);

 

FirstofMonth = jsDate;

 

var month =FirstofMonth.getMonth();

 

if (month<10){

month = "0" + month.toString()

}

 

var day = FirstofMonth.getDate();

 

if (day<10){

day = "0" + day.toString()

}

 

var year = FirstofMonth.getFullYear();

 

NewHireDateStartPT=month.toString()+'/'+day.toString()+'/'+year.toString(); to value 00/01/2020

 

There is a 2nd calculation after this script that calculates the last day of the month, which comes up correctly with 12/31/2019.  Any thoughts as to what we might be missing in the script?  Thank you in advance!

David Williams
Veteran Member Send Private Message
Posts: 1127
Veteran Member
In JavaScript, the first month is zero. 0=Jan 1=Feb 2=Mar
David Williams