Begin Date to End Date duration cannot exceed one year

[Cupcake]

I have a need to make sure that the duration between the Begin Date and End Date does not exceed 1 year.

I used scripting before to make a date go out to xxx amount of days, but never to actually do a calculation between Begin and End dates

I don't have a Due Date field. I just have the Start and End Date field and I need to make sure that Duration cannot exceed 1 year.

[Cupcake]

Hi Mike,

        Yes all is well. I marked your answer as the Correct Answer; however, I used the sample script that you provided but it doesn't seem to calculating. Can you take a look for me.

So I have a Begin Date and an End Date. The duration of those days should not exceed 365 days and I am only using the Date not the Date / Time.

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

      if (isLoading || newValue == '') {

              return;

      }

      var starts = g_form.getValue('priv_begin_date');

      startMillis = getDateFromFormat(starts, g_user_date_time_format);

      var ends = newValue;

      endMillis = getDateFromFormat(ends, g_user_date_time_format);

      var minutes = (endMillis - startMillis) / (1000 * 60);

      if(minutes > 525600) {

              alert('Duration between the begin and end dates cannot exceed 365 Days');

              g_form.setValue('priv_end_date', '');

      }

}

[Michael Ritchie]

Karen, the getDateFromFormat() function is expecting date and time and with your variables being only a date, that is what is tripping it up.   No big deal as we can easily turn your date into a date/time by adding ' 00:00:00' to each date.   The following worked in my quick test:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {
       if (isLoading || newValue == '') {
               return;
       }

       var starts = g_form.getValue('priv_begin_date') + ' 00:00:00';
       startMillis = getDateFromFormat(starts, g_user_date_time_format);

       var ends = newValue + ' 00:00:00';
       endMillis = getDateFromFormat(ends, g_user_date_time_format);

       var minutes = (endMillis - startMillis) / (1000 * 60);

       if(minutes > 525600) {
               alert('Duration between the begin and end dates cannot exceed 365 Days');
               g_form.setValue('priv_end_date', '');
       }
}

[Cupcake]

It still accepted the request, not working

Begin Date = today's date

End Date = October xx, 2017

That is more than 365 Days. Not sure what the issue is ate this point.

[Michael Ritchie]

Just to confirm, are these variables on the service catalog?   Believe you had mentioned service catalog earlier.

I tested the code on catalog variables and also tested it on change with the work_start and work_end out of the box dates and it worked.

You can try putting a few alert()'s in there to see the values of the start and end calculations:

var starts = g_form.getValue('priv_begin_date') + ' 00:00:00';

startMillis = getDateFromFormat(starts, g_user_date_time_format);

alert('startMillis: ' + startMillis);

var ends = newValue + ' 00:00:00';

endMillis = getDateFromFormat(ends, g_user_date_time_format);

alert('endMillis: ' + endMillis);

[Cupcake]

Yes the priv_begin_date and priv_end_date are variables on that catalog item.

I used the onChange catalog client script. The script is below maybe the variable name should be on the priv_begin_date .