2 Replies Latest reply on Jun 16, 2017 11:54 AM by Joel_Geraci

    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.

      Ex:

      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 = "";

          }

      })();