Begin Date to End Date duration cannot exceed one year

Cupcake
Mega Guru

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.

1 ACCEPTED SOLUTION

Michael Ritchie
ServiceNow Employee
ServiceNow Employee

Hello Karen, its been a while hope you are well!



Here is some example code I have used before.   Do you want the validation to happen on submit or as the user is inputting the data?   My code below is based on an onChange of the Work End date on a task, but you could change it to an onSubmit can calculate and warn then.



Create a onChange client script for the End date:


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', '');


      }


}



Obviously you will need to calculate the a year to then compare for your alert.   Thinking out loud an onSubmit may be better because you can prevent the save if it exceeds a year.


View solution in original post

27 REPLIES 27

Karen, sorry I have been and still traveling.   Yes since you are getting a value of zero that is absolutely the cause of your issue.   I would continue to troubleshoot the start and end values.


Hi Mike here is the script that was used that actually works:



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_format);



      var ends = g_form.getValue('priv_end_date');


      endMillis = getDateFromFormat(ends, g_user_date_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', '');


      }


}


Awesome very happy you got this sorted.


Hi Karen,



i am new to service now.
Thanks for the post and is really helpful.


when i am trying it on submit the request is getting submitted without error.


could you please help me on this





find_real_file.png


Abhinay Erra
Giga Sage

Sorry I am confused here. What is the field you want to validate for field length and only digits?