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.
Solved! Go to Solution.
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
Can you provide some sample input and expected output it will help us get a better understanding of the usecase.
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.
You are using datetimeformat which is not right you should use datetimeparse refer my first post.
Hope this helps : )
Would having null values in the same column cause the DateTimeParse to not work? Still getting 1900-mm-dd
Here's a workflow using your file and @atcodedog05's DateTimeParse([Date],"%m/%d/%Y") function. All the dates get converted properly.
Dan