Replacing a column with today's date with a formula

[Axis]

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 solution]

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 solution]

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

[Axis]

Hi, 

Thanks for the quick help! 

My error was to put an "=" at the begining of the formula... 😁 
Excel habits... 

Have a nice day!