question Re: Due date script in flow designer returns incorrect value in Developer forum

Due date script in flow designer returns incorrect value

kchorny — Tue, 13 Aug 2024 20:40:37 GMT

I have this script on a Catalog task Due date field. It's supposed to set the due date of the task to 5pm ET 3 days after an event date. Our instance is set to ET, and the schedule and child schedule is set to ET.

When I run the script, the logs show 5pm on the due date, but when it actually sets the value of the due date field on the task, it sets it to 1pm.

var endDate = fd_data._20__for_each.item.date_s_and_time_s_of_the_event; var endDateTime = new GlideDateTime(endDate); gs.log('EndDateTime: ' + endDateTime,"KC"); //Returns 2024-08-30 00:00:00 endDateTime.addSeconds(61200); //Set date to 5pm on date of event (17hrs*60mins*60secs) gs.log('EndDateTime: ' + endDateTime,"KC"); //Returns 2024-08-30 17:00:00 var dur = new GlideDuration('0 27:00:00'); //3 days = 27 hours on an 8-5 schedule var sched = new GlideSchedule('090eecae0a0a0b260077e1dfa71da828'); //8-5 weekdays excluding holidays var dueDate = sched.add(endDateTime,dur); gs.log('DueDate: ' + dueDate,"KC"); //Returns 2024-08-30 17:00:00 return dueDate;

Seems like it's seeing the due date as the UTC time, and then setting it to ET in the task. How do I fix this?

Re: Due date script in flow designer returns incorrect value

Slava Savitsky — Tue, 13 Aug 2024 22:36:16 GMT

In the context of which user does your script run? What time zone is set in that user's profile?

Re: Due date script in flow designer returns incorrect value

Sheldon Swift — Tue, 13 Aug 2024 23:56:42 GMT

Try like this:

var endDate = fd_data._20__for_each.item.date_s_and_time_s_of_the_event; // Initialize the GlideDateTime with the event date var endDateTime = new GlideDateTime(); endDateTime.setDisplayValue(endDate + ' 17:00:00'); // Set to 5 PM ET gs.log('Event DateTime (5 PM ET): ' + endDateTime.getDisplayValue()); // Define the schedule (8-5 weekdays excluding holidays) var sched = new GlideSchedule('090eecae0a0a0b260077e1dfa71da828'); // Add 3 business days to the event date var dueDate = sched.add(endDateTime, new GlideDuration('3 00:00:00')); // The resulting due date should also be at 5 PM ET on that date. dueDate.setDisplayValue(dueDate.getDisplayValue().split(' ')[0] + ' 17:00:00'); gs.log('Due DateTime after adding 3 business days: ' + dueDate.getDisplayValue()); // Check the UTC time of the due date gs.log('Due DateTime in UTC: ' + dueDate.getValue()); // Output the due date in ET (should already be in the correct time zone) gs.log('Final DueDate in ET: ' + dueDate.getDisplayValue());

If you're still having issues, double-check the time zone on the schedule itself.

Re: Due date script in flow designer returns incorrect value

kchorny — Wed, 14 Aug 2024 11:53:29 GMT

Thank you!!! This worked like magic! The only exception is that I had to change the GlideDuration from '3 00:00:00' to '0 27:00:00'. Otherwise it added 8 days ((3 days*24 hours)/9 business hours) instead of 3.

Re: Due date script in flow designer returns incorrect value

Slava Savitsky — Wed, 14 Aug 2024 12:24:11 GMT

Be careful with parsing date/time display values. GlideDateTime objects' getDisplayValue() method returns the date and time in the current user's display format and time zone. It can have a different value and syntax depending on which user's context the script will run in.

Re: Due date script in flow designer returns incorrect value

Sheldon Swift — Wed, 14 Aug 2024 13:02:21 GMT

Great point, @Slava Savitsky. Let’s correct that and offer an alternative solution using methods that work independently of user-specific settings.

var endDate = fd_data._20__for_each.item.date_s_and_time_s_of_the_event; // Initialize the GlideDateTime with the event date var endDateTime = new GlideDateTime(); endDateTime.setValue(endDate + ' 21:00:00'); // Set to 5 PM ET, which is 21:00:00 UTC gs.log('Event DateTime (5 PM ET): ' + endDateTime.getValue()); // Using getValue() for consistency (UTC time) // Define the schedule (8-5 weekdays excluding holidays) var sched = new GlideSchedule('090eecae0a0a0b260077e1dfa71da828'); // Add 3 business days to the event date var dueDate = sched.add(endDateTime, new GlideDuration('0 27:00:00')); // The resulting due date should also be at 5 PM ET on that date. var dueDateValue = dueDate.getValue().split(' ')[0] + ' 21:00:00'; // Adjust to 21:00:00 UTC which is 5 PM ET dueDate.setValue(dueDateValue); gs.log('Due DateTime after adding 3 business days: ' + dueDate.getValue()); // Using getValue() for consistency (UTC time) // getValue provides UTC gs.log('Final DueDate in UTC: ' + dueDate.getValue()); // getDisplayValue provides ET gs.log('Final DueDate in ET: ' + dueDate.getDisplayValue());