We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

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
Top Solution Authors