Need to subtract or minus 5 business days from a date/time field on the Catalog form.

Rmohan
Mega Expert

Hi,

I have a requirement for setting a field value as 5 business days minus the set date on the another field on a catalog form.

For example-

If the Delivery_Date is set as 11-15-2019, the Actual_Start_date should be 11-08-2019, taking into account the 8-5 weekday schedule.

Looking for on how to configure the Actual_Start_date.

The delivery date can be modified by the user submitting the request, so I know it should be a catalog client script, but I am quite new to coding and after thoroughly searching the community, could not find the answer I needed.

So requesting the ServiceNow Community for assistance.

Thanks.

1 ACCEPTED SOLUTION

Rmohan
Mega Expert

Hi All,

I finally made is possible by following a minimal scripting method using the Timer.

As suggested by TJW in set a timer in workflow based on a variable, I was able to set the schedule and make the timer wait as per my needs.

Thank you all for your support 🙂 

View solution in original post

39 REPLIES 39

Rmohan
Mega Expert

Hi All,

Does having a default value set at Start_date field through scripting, makes any difference to this code?

I have a script which sets the default value to 10 business days ahead of the date on which the request is being opened.

*Sorry not the Start_date but the Delivery_date field. The default value is set on Delivery_date field.

Just noticed, your script include name and function name does not match the one's mentioned in the client script , can you change that?

Thanks

Hi Vignesh, 

Changed the name too, but still not working. Or is it somewhere else that I need to make changes? Sorry I am not so fluent in scripting.

find_real_file.png

Thanks

Its still not right . Names are not matching.