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!

[Chuck Tomasi]

Hi Danielle,

This is a fairly common question and one that is documented. Take a look here.

http://wiki.servicenow.com/index.php?title=Using_DurationCalculator_To_Calculate_a_Due_Date#gsc.tab=...

[daniellethomson]

thanks Chuck. I have been trying to create my script from that but It's only pulling the getnow date and time into the variable. I'm a little new to scripting so I must be missing something.

// 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(leadTimeSeconds*1000);  

var dueDateGdt;  

var schedRec = new GlideRecord('cmn_schedule');  

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

        var sched = new GlideSchedule(schedRec.sys_id);  

        dueDateGdt = sched.add(nowGdt, leadTime, '');  

}  

dueDateGdt;

[Chuck Tomasi]

Can you tell me where this script is being used? Is it a business rule? A workflow script?

[daniellethomson]

Hi Chuck,

I am using this script in the default value of the variable.