Set RITM Due Date to date/Time variable plus 3 days 4 hours

[booher04]

I have another item where I have set the due date to 10 business days from the opened date of the item, however I have a little more tricky one.  I need to take the date/time from a variable(date_time_deployment) the user selects and add 3 business days and 4 hours to it for the due date.  I put together this script to get the 3 days as a start but it's not working correctly.  Any ideas on how to get this accomplished?  I'm using a business rule to accomplish this.

var schedRec = new GlideRecord('cmn_schedule');

schedRec.get('name', '8-8 weekdays excluding holidays');

if (typeof GlideSchedule != 'undefined')

var sched = new GlideSchedule(schedRec.sys_id);

else

var sched = new Packages.com.glide.schedules.Schedule(schedRec.sys_id);

//Get the current date/time in correct format for duration calculation

var currentDateTime = current.variables.date_time_deployment;

//Set the amount of time to add (in seconds)

var timeToAdd = 3 * 43200;

durToAdd = new GlideDuration(timeToAdd*1000);

var newDateTime = sched.add(currentDateTime, durToAdd, '');

//Set the 'due_date' field to the new date/time

current.due_date = newDateTime;

[Ali Shaikh1]

Hi,

Please go through the script for 3 working days. 

var schedRec = new GlideRecord('cmn_schedule');

schedRec.get('name', '8-5 weekdays');

if (typeof GlideSchedule != 'undefined')

var sched = new GlideSchedule(schedRec.sys_id);

else

var sched = new Packages.com.glide.schedules.Schedule(schedRec.sys_id);

//Get the current date/time in correct format for duration calculation

var currentDateTime = current.opened_at.getGlideObject();

//Set the amount of time to add (in seconds)

var timeToAdd = 8 * 32400;

durToAdd = new GlideDuration(timeToAdd*1000);

var newDateTime = sched.add(currentDateTime, durToAdd, '');

//Set the 'due_date' field to the new date/time

current.due_date = newDateTime;

Ali Shaikh.

[booher04]

Thank you, but I've tried this and replaced the schedule with our 8-8 schedule... i've also replaced the opened_at variable with our variable.  It's not working correctly.

[booher04]

The code below is working as far as the calculations go, however it's using the opened_by date.  As soon as I change the script to look at the variable date_time_deployment it not longer works and the Service Portal throws a quick exception error and submits but I can't read it all before it goes away.

var schedRec = new GlideRecord('cmn_schedule');

schedRec.get('name', '8-8 weekdays excluding holidays');

if (typeof GlideSchedule != 'undefined')

var sched = new GlideSchedule(schedRec.sys_id);

else

var sched = new Packages.com.glide.schedules.Schedule(schedRec.sys_id);

//Get the current date/time in correct format for duration calculation

var currentDateTime = current.opened_at.getGlideObject();

//Set the amount of time to add (in seconds)

var timeToAdd = 3 * 43200 + 4 * 3600;

durToAdd = new GlideDuration(timeToAdd*1000);

var newDateTime = sched.add(currentDateTime, durToAdd, '');

//Set the 'due_date' field to the new date/time

current.due_date = newDateTime;

[Tanaji Patil]

May I ask where you are writing this script?

-Tanaji
Please mark reply correct/helpful if applicable