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

[Rmohan]

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.

[Rmohan]

Hi Omkar,

Thank you again for the all the help, however I tried to insert the given script in the script include, but that was throwing me an error.

Can you please help me on that too?

Thanks

[rajesh9885]

Can you show please show the error and the script again at your end

also

please have look at this as well

https://community.servicenow.com/community?id=community_question&sys_id=c9cbcfa1db9cdbc01dcaf3231f96199c
https://community.servicenow.com/community?id=community_question&sys_id=40ef47a5dbdcdbc01dcaf3231f961947
https://community.servicenow.com/community?id=community_question&sys_id=f34bc321db9cdbc01dcaf3231f96197c

[Rmohan]

Hi Rajesh,

I am unable to view the content of the link, can you please share the link again?

Thanks

[rajesh9885]

https://community.servicenow.com/community?id=community_question&sys_id=c9cbcfa1db9cdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=40ef47a5dbdcdbc01dcaf3231f96...

https://community.servicenow.com/community?id=community_question&sys_id=f34bc321db9cdbc01dcaf3231f96...

[Rmohan · Accepted solution]

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 🙂