Business Rule to calculate due date 3 days in the future and following the 8-5 weekdays schedule

[daniellethomson]

I can't seem to figure out how to add a schedule to a script that calculates a custom targeted due date field based on a requested_date variable. I would like the script to take todays date and add 3 days excluding weekends. Does anyone have this script already?

Thanks!

[JohnG3]

Hi Danielle,

You might need to change:

if (schedRec.get('8-5 weekdays', myScheduleName))

to

if(schedRec.get('name', myScheduledName))

For reference: GlideRecord - ServiceNow Wiki

Thanks,

John

[daniellethomson]

Thanks John. I updated the script that is being used in the default value of the variable and I'm still receiving the same results.

[JohnG3]

Hi Danielle,

You might also need to change the calculation of leadTime to use "dueSeconds":

var leadTime = new GlideDuration(dueSeconds*1000);

When I tried this in my instance:

// Get the datetime now
var nowGdt = new GlideDateTime();

// Get the datetime now
var nowGdt = new GlideDateTime();
// The name of the schedule 
var myScheduleName = '8-5 weekdays'; 

// The basis of our calculation 
var dueDays = 3; 
var dueWorkingHours = 8; 

var dueSeconds = dueDays*dueWorkingHours*60*60; 
var leadTime = new GlideDuration(dueSeconds*1000); 

var dueDateGdt; 
var schedRec = new GlideRecord('cmn_schedule'); 
if (schedRec.get('name', myScheduleName)) {               
         var sched = new GlideSchedule(schedRec.sys_id); 
         dueDateGdt = sched.add(nowGdt, leadTime, ''); 
} 
gs.log("Result=" + dueDateGdt);

It seemed to return the correct date: *** Script: Result=2017-04-20 16:47:46

Thanks,

John

[daniellethomson]

Interesting, I tried the updated script on your environment as the variables default value and it is still only posting the current time/date. I don't have any other scripts or business rules running on this catalog item.

[keithlyon]

This works perfectly in a business rule. Thanks for sharing!