Hey Everyone, I thought it might be handy to share my Flow Designer action to add business days to a time. We use this to calculate due dates in the future, or SLA due times.
Here's the inputs I have:
And the script Step:
(Here's the script itself: )
(function execute(inputs, outputs) {
var newDateTime;
var timeToAdd;
var currentDateTime = new GlideDateTime();
var msInDay = 24 * 60 * 60 * 1000; //One day in Milliseconds as default day
var msInBusDay = 24 * 60 * 60 * 1000; //One day in Milliseconds as default business day;
if (!inputs.startTime) {
newDateTime = new GlideDateTime();
}
if (inputs.useSched == true && (inputs.sched)) {
// Here's a line of javascript that is terrible. It relies on a specific day I picked to be a "generic Business Day". Don't use it. I'm sorry.
//msInBusDay = new GlideDateTime(new GlideSchedule(inputs.sched.getUniqueValue()).duration(new GlideDateTime("2019-02-12 00:00:00"), new GlideDateTime("2019-02-13 00:00:00")).getValue()).getNumericValue();
msInBusDay = 8 * 60 * 60 * 1000; //SET THIS (8) TO YOUR BUSINESS DAY LENGTH IN HOURS, OR, USE MY SUPER LINE ABOVE TO CALCULATE ;)
var sched = new GlideSchedule();
sched.load(inputs.sched.getUniqueValue());
var durCalc = inputs.daysToAdd * msInBusDay;
var durToAdd = new GlideDuration(durCalc); // Translate into Duration Object.
var d = new GlideDateTime();
d.setDisplayValue(inputs.startTime.toString());
newDateTime = sched.add(d, durToAdd);
} else {
newDateTime = new GlideDateTime();
newDateTime.setDisplayValue(inputs.startTime.toString());
timeToAdd = msInDay * inputs.daysToAdd;
newDateTime.add(timeToAdd);
}
outputs.outDateTime = newDateTime;
})(inputs, outputs);
And pass the output back to the Action Outputs section, and you are done!
PLEASE NOTE: My script was built for my business, and you may have to change it for your days. The "Crazy" line of javascript was specifically to calculate a day based on multiple schedules
Take this as a guide, and go to town!
Special thanks to my friend Kevin from Australia Post for some duration logic!
Keep living that #Fladvoate life!
- Andrew
