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 ?

[echuong1 · Accepted solution]

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...

[MarqueeCrew]

@b_sab ,

I use:  DateTimeStart() !!!!

datetimenow() changes during the run. If you span midnight, you can get rows of data with different dates. 

Cheers,

 mark