Set cu-off period

Question

Hi Everyone,

I would like to set a cut-off period condition on my workflow. If the last action date is beyond 16:00:00 (24hr format) then it would be tagged as "past cut-off" else "no".

sample date format:

2023-04-04 16:18:00

2023-04-04 17:32:00

Thank you in advance!

mceleavey · Accepted Answer

Hi @mhtomines ,

this is a simple formula:

You can use the following formula to achieve this:

if datetimeformat([Last Action Date],"%T")>datetimeformat("16:00:00","%T") then "Y" else "N" endif

This converts the datetime into a time format, and compares the converted time to the cut-off time.

I hope this helps,

M.