Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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