How can we get the current date/time to be used within a Workflow?

zacpolin

I'm using a workflow to append to a dataset and I'd like to include the current date/time as a column in the dataset based on when the workflow was executed. Is there a way to capture this information?

Thanks!

MarkSnodgrass

I would try using the Query Table tile and then pick any dataset and then write the following SQL query:
SELECT CURDATE() As TodaysDate FROM Table_0 LIMIT 1

MarkSnodgrass

I would try using the Query Table tile and then pick any dataset and then write the following SQL query:
SELECT CURDATE() As TodaysDate FROM Table_0 LIMIT 1

zacpolin

Thank you @MarkSnodgrass! That worked. I actually updated it to to show the date and time.

SELECT CONCAT(CURDATE(), ' ', CURTIME()) As DateTime FROM Table_0 LIMIT 1