Why the business duration is resulting in 0 seconds where it should be 1 hour 19 minutes as I have used OOB
8-5 weekdays excluding holidays schedule where the start time as 8.
Thanks
Thanks
1 ACCEPTED SOLUTION
check this link and it talks about using PlannedTaskAPI to calculate the duration
Calculate the business duration using a schedule
I ran the same script and in preferences set the timezone as GMT and it gave me the correct output
try {
var schedule = new GlideSchedule("08fcd0830a0a0b2600079f56b1adb9ae", );
var open = new GlideDateTime('2025-01-03 07:00:00');
var closed = new GlideDateTime('2025-01-03 09:19:00');
// Use closed_at for "mark_closed" business rule and resolved_at for "mark_resolved" business rule
var plannedTaskAPI = new SNC.PlannedTaskAPI();
var resp = plannedTaskAPI.calculateDuration(open.getDisplayValue(), closed.getDisplayValue(), '08fcd0830a0a0b2600079f56b1adb9ae');
var response = new JSON().decode(resp);
var duration = response.duration;
gs.info(duration);
} catch (ex) {
gs.info(ex);
}
If my response helped please mark it correct and close the thread so that it benefits future readers.
