Excel date being converted from mm/dd/yyyy to 1900-mm/dd after data cleansing

[pattersonmichaelk]

I'm trying to compare 2 dates from different spreadsheets but running into an issue where data cleansing is converting 07/28/2025 (Excel custom format) to 1900-01-06 which obviously makes comparing dates impossible.

[atcodedog05]

Hi @pattersonmichaelk 

You can convert the date like below.

Workflow:

Hope this helps : )

[pattersonmichaelk]

That's the formula I've been trying to use and then noticed the data was being from 07/28/2025 converted to the below after data cleanse

[atcodedog05]

Hi @pattersonmichaelk 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[pattersonmichaelk]

Input 

Trying to convert to the below format so a formula can be added to ensure they are the same date

But Alteryx is converting the input to for all dates to 1900-mm-dd. Need help converting the 1900 year to the proper year such as 2025 above.

[atcodedog05]

Hi @pattersonmichaelk 

You are using datetimeformat which is not right you should use datetimeparse refer my first post.

Hope this helps : )

[pattersonmichaelk]

Would having null values in the same column cause the DateTimeParse to not work? Still getting 1900-mm-dd

[atcodedog05]

Hi @pattersonmichaelk 

Please provide an excel file with sample data we can take a look into it.

[pattersonmichaelk · Accepted solution]

Sample excel input attached.

[danilang]

Hi @pattersonmichaelk 

Here's a workflow using your file and @atcodedog05's DateTimeParse([Date],"%m/%d/%Y") function.  All the dates get converted properly.

Dan