Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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