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 Michael,

        The code is working as intended. I have another small question. Now as part of the requirement they want to ensure that the characters are numeric only. I've done this for an onChange script by using the following code. But how can I incorporate this into the script that you provided.

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

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

                  return;

        }

      var num = new RegExp("^[0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9][0-9]$");

        if(!num.test(newValue)){

                  alert('Please enter numbers only in this field');

                  control.value = oldValue;

        }

}

Thanks,

Karen

[Michael Ritchie]

Karen, which field are only numeric characters expected?   Is this for the same end date field or another field?

[Cupcake]

Yes it is.

[Abhinay Erra]

Here you go.

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

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

                  return;

        }

        if(/\D/g.test(newValue)){

                  alert('Please enter numbers only in this field');

                  control.value = oldValue;

        }

}

[Cupcake]

Thank you Abhinay.

      The issue is a little more than that. I have an onSubmit client script that will check to ensure that the duration between Begin and end date does not exceed 1 year, the max_length of that field can only be 11 character (not more or less) and now they want to ensure that the characters are only numeric. Here is the onSubmit script that was provided by Michael. If I do the onChange script, along with the onSubmit script they will collide.

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

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

              return;

      }

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

      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 > 480) {

              alert('An Activity may only last 8 hours.   You must enter multiple activities if the time required exceeds 8 hours.');

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

      }

}