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

daniellethomson · ‎04-13-2017

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 · ‎04-18-2017

Hi Danielle,

Strange, I created a test Catalog Item with a Date/Time variable and used the script, but changed line 22 to just:

dueDateGdt;

It seemed to work for me to set the date for 3 days.

Screenshot of Date/Time variable:

Screenshot of Default Value of Date/Time variable:

Default Value code:

javascript: var nowGdt = new GlideDateTime(); var nowGdt = new GlideDateTime(); var myScheduleName = '8-5 weekdays'; 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, '');} dueDateGdt;

Thanks,

John

P.S. Normally, we would create a custom Script Include with a helper function: getDueDate('schedule_name', 'number_of_days') and then use that for the variable default value: javascript:new myCatalogVariableHelper().getDueDate('8-5 Weekday', 3);

View solution in original post

Goran WitchDoc · ‎04-18-2017

Perhaps this post can shine some light for you: How to close ticket after 3 business days

//Göran