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 

Can you try this - 

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

Just added toString() in the return statement.

Try this and let me know.

Regards

Omkar Mone

[Rmohan]

Thank you Omkar for your response.

Tried it and still not working.

I even tested and submitted the request to see if may be the field is getting generated on submit, but no avail there too.

[Omkar Mone]

Hi 

Can you put some log statements and check what you are getting?

I have put the logs, copy it and check it in the system logs - 

var AjaxDurCalc = Class.create();
AjaxDurCalc.prototype = Object.extendsObject(AbstractAjaxProcessor, {
    durCalc: function() 
    {
        var deliver = this.gertParameter('sysparm_deliv');
        gs.log("Date Recieved = "+deliver);
        var ps = new GlideDateTime(deliver);
        ps.addDays(-5);
        var datebefore = ps.getDate();
        gs.log("Date Before = "+datebefore);
        //return datebefore.toString();
    },
    type: 'AjaxDurCalc'
});

[Rmohan]

Hi Omkar,

I updated the script include and checked the logs at syslog.list but could not find anything with Date Received or Date Before.

[VigneshMC]

There is a spelling mistake on this line

        var deliver = this.gertParameter('sysparm_deliv');

it should be 

        var deliver = this.getParameter('sysparm_deliv');