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.

[Omkar Mone]

Hi 

Where do you want to add the schedule?

[Rmohan]

In the actual_start_date.

I want that what the delivery_date the user is choosing, the actual start date should be 5 business days before it not calendar days.

With your and community's help we set it up for calendar, however is there a way we can add the "8-5 weekday" schedule to make it business days?

[Omkar Mone]

Hi 

So when someone tries to select the date, if it is a weekend you dont want to accept the date right?

[Rmohan]

Hi,

No, I want the subtract of the date to be 5 business days.

For example taking today.

If someone selects Delivery_date as 4th Nov, the actual start date at this moment is coming as 29th Oct, because it is counting the weekend as well.

I want this actual_start_date to come as 27th Oct, skipping the weekend.

Just like we have schedules- 8-5 weekend etc.

[Omkar Mone]

Hi 

This might help, do these in the script include - 

https://www.servicenowguru.com/scripting/business-rules-scripting/schedule-time-addition/