Hi Everyone !
I am looking for ways to approximate my minutes value of date time to next multiple of 5.
for example 2017-09-01 02:26:00 to 2017-09-01 02:30:00, 2017-09-01 02:44:00 to 2017-09-01 02:45:00.
This solution should work. It converts the date to seconds, adds 5 minutes, reconstructs date, then rounds down the minutes the 5 multiple.
I've attached a sample workflow.
Flow:
Input:
Results:
Formulas:
Regex:
Try using this flow. Parse out the date with Regex, round the minute to the next multiple of 5, then reconstruct the date.
Formula:
Actually, please ignore that. it won't round up the hour,day, month, or year. Reworking a way by converting to seconds, adding 5 minutes, then rounding down the minutes.
