Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to add timestamp on my Timestamp column everytime I run the workflow?

jayross0117
6 - Meteoroid

I want to add the date and time of when the workflow finished running on my "Timestamp" column. Instead of using DateTimeToday() formula, what else can I use that includes also the time? Thanks

 

jayross0117_0-1573401195390.png

3 REPLIES 3
neilgallen
12 - Quasar
Datetimenow()

Should give you the current date and time, provided the field is the correct format.
danilang
19 - Altair
19 - Altair

Hi @jayross0117 

 

@neilgallen has a great suggestion using DateTimeNow().  Your only issue in using it is that it returns the date time at the moment it's called.  If you have a workflow that takes a long time to run, DateTimeNow() can produce different results in your output.  To get a constant value, you can use DateTimeStart(), which returns the time the current workflow started running.

 

Dan 

jayross0117
6 - Meteoroid

Thank you @danilang . It's working now. 

Labels