Hello,
I’m trying to setup a standard transaction group to run every hour, but I need it to run every exact hour (0 minutes, and 0 seconds)so I’m using the Schedule option like this: 00:00,1:00,…,23:00
There is one field (named Status) in my database that I want to fill with a ‘1’ only at certain hours, say 5:00 and 8:00, but I want to store a ‘0’ for all other hours
I was thinking about using an expression item to get the hour from the timestamp like this:
Expression:
dateExtract(TransactionTimeStamp(),“hour”)=5
|| dateExtract(TransactionTimeStamp(),“hour”)=8
But I don’t know how to get the timestamp of the transaction.
I guess the “now()” function could help, but I think it is not exactly the same as the timestamp
Is there a way to do this?