I have a table where several emails are sent from workflows based on when the table gets updated…
Class table - Announced, Confirmed (both date/time fields)
When the field gets stamped with NOW(), the workflow “on update” fires off the appropriate report, either Class Announced email or Class Confirmed email.
Problem is that both workflows send an email EVERYTIME the table is updated, so I’ve started to implement conditions.
Im trying to set the following condition for each of the workflows:
([Announced Date Time] >= (Now() - SECOND(“010:00:00”))))
This would ONLY send the workflow if the Announced DateTime value is within 10 seconds of Now()
Problem is that I cant get Now()-10 seconds to work … no matter what I do…