Time stamp older than 10 seconds

Hi,

I have a workflow to clear values from cells if the corresponding time stamp is older than 10 seconds.

As a condition in the workflow I have.

It will allow = but not <
[Run 2]=(TIMENOW() - “00:00:10”)

Not sure if this is the correct way to express: value in column run 2 is older than 10 seconds

[Run 2]<(TIMENOW() - “00:00:10”)

thanks

Phil

I don’t think this is going to work at all. Workflows are only triggered during an update of that table. At the time of the update when the Timestamp is added, the workflow will get triggered, but the Timestamp won’t yet be older than 10 seconds. It won’t check again until you or a user initiates another update on that table.

1 Like

HI Dave,

The update doesn’t trigger the timestamp. The workflow has conditions when to apply and ends a long sequence.

thanks

Phil

TIMENOW() produces a Time value. "00:00:10" is a Time value (12:10 AM). Subtracting one Time value from another Time value produces a Duration value. Is [Run 2] also a Duration value?

To calculate a time in the past, subtract a Duration value from a Time value:

(TIMENOW() - "000:00:10")

Note that a literal Duration value has at least three digits in the hours position, whereas a Time value has at most two digits.

1 Like

Well, if the workflow can get fired regardless, then the expression should be
[Run 2]+"000:00:10">=TIMENOW() or some form of it.

Thank you

Phil