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]

Can you please share the correct code? I might not be able to get the correct place where you wanted the change.

[VigneshMC]

[Rmohan]

Did the same changes, nothing.

Is the OnChange script correct? I mean I tried to change the date on the form and still the Actual Date did not populated.

Should I try the OnLoad or is it something else which is messing this up?

[VigneshMC]

Can you share your current scripts ?. Also try adding alert of answer

[Rmohan]

Sure,

So I have 2 fields, Delivery_date and Actual_start_date.

I have the default value set to add 10 business days to Delivery_date from the date of opening the catalog form using-

javascript:var gdt = new GlideDateTime();
var dc = new DurationCalculator();
dc.setSchedule('db58361cdbf317003e8a0f4dca96196e'); // Schedule sys_id
dc.setStartDateTime(gdt);
dc.calcDuration(10*10*3600); // 8-6 Schedule so 10 Hrs

var edt= new GlideDateTime(dc.getEndDateTime())
edt.getDate();

Then as Ajay suggested, I am using the Catalog Client Script and Script Include to populate the Actual_start_date field.

Catalog Client Script-

function onChange(control, oldValue, newValue, isLoading) {
if (isLoading || newValue == '') {
return;
}
//Type appropriate comment here, and begin script below
var deliverydate= g_form.getValue('delivery_date');//variable field
var ajax = new GlideAjax('AjaxDurCalc');
ajax.addParam('sysparm_name','durCalc');
ajax.addParam('sysparm_deliv',deliverydate);
ajax.getXMLWait();
var answer = ajax.getAnswer();
g_form.setValue('actual_start_date', answer);
}

And the Script Include-

var AjaxDurCalc = Class.create();
AjaxDurCalc.prototype = Object.extendsObject(AbstractAjaxProcessor, {
days:function(){
var deliver=this.gertParameter('sysparm_deliv');
var ps = new GlideDateTime(deliver);
ps.addDays(-5);
var datebefore =ps.getDate();
return datebefore;
},
type: 'AjaxDurCalc'
});