Date time Aproximation

[eamritraz]

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.

[JoshKushner]

Try using this flow. Parse out the date with Regex, round the minute to the next multiple of 5, then reconstruct the date.

Flow:

 

Input:

Results:

Regex:

Formula:

[JoshKushner]

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.

[JoshKushner · Accepted solution]

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:

[eamritraz]

Thanks Josh!