3 Replies Latest reply on Apr 13, 2018 9:43 AM by r.armont

    Calculate date + 30 days then first of following month

    r.armont Level 1

      I have a calculated field in my form that adds 30 days to a date entered into DateofHire. I need the resulting date to be the first of the following month.


      Using a hire date of 7/1/17 my script results in 7/31/17, I need to calculate it to 8/1/17.

      If the hire date is 7/2/17, the script results in 8/1/17, I need the field to go to 9/1/17.


      I hope that makes sense. Here's my current script:


      // Custom Calculate script for NewDate field


      (function () {

          // Get date entered into the DOH field

          var sDate = getField("DateofHire").valueAsString;


          // Convert string to date

          var d = util.scand("mm/dd/yyyy", sDate);


         // Add days to date

          d.setDate(d.getDate() + 30);


          // Populate this field with the result

          if (sDate) {

              event.value = util.printd("mm/dd/yyyy", d);

          } else {

              event.value = "";