the real datetimenow ?

b_sab

I have a workflow that is scheduled at 11pm. due to some server delay, it might take up until 1:30am to start running (queued from 11pm tp 1:30am). If the workflow starts running at 11pm, then I need to get data for current day, if it starts running at 1:30am, then I need to get data of pervious day (from my input).

the question is, the datetimenow function is based on the workflow "date created" time in the server or the actual time when it starts running ?

Capture.JPG

echuong1

Datetimenow() pulls the current date and time at runtime.

Thinking about your issue, you can probably pull the datetimenow and then use a formula to adjust the date pulled. From there, you can use a dynamic input to adjust the query.

See this link for more information: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/DateTimeNow-Tool-as-input-to-Action/td-p/183666