CONVERTING 1900 DATE TO EXACT DATE

[dunkindonut7777]

Hi How can I convert "1900-01-01" this date format into current year or exact date in alteryx? Any formula that I could convert it?

[Luke_C]

Hi @dunkindonut7777 

Might be helpful to have a bit more context on your data - when you say current year/exact date, do you mean 2022-01-01? Today's date? Something else?

Assuming your field has other dates, you could do something like the below in a formula tool to update these with today's date.

IF [Field] = '1900-01-01'
Then DateTimeToday()
Else [Field]
Endif