Replacing a column with today's date with a formula

Question

Hi all,

I'm quite new with Alteryx and I have a basic question but I can't find the answer on internet.

It should be quite simple but I'm blocking.

I have a column with various data in it : differentes dates, blanks, etc.

I want to replace all the values in that column with today's date in that format : dd/mm/yyyy
I want to do this preferably with a formula.

I tried many different formulas but I receive always an error.

Thanks a lot for your help.

Best regards.

Emil_Kos · Accepted Answer

Hi @Axis,

The answer to your problem is DateTimeToday formula.

and the output:

Please mark my post as a solution if this is useful for you!

Good luck!

JosephSerpis · Accepted Answer

Hi @Axis I mocked up a workflow that formats that date in the format : dd/mm/yyyy