Date properly formatted in Excel do not convert to alteryx date format

I am trying to work on an Excel spreadsheet imported with correctly formatted dates. When the dataset is imported to Alteryx everything seems fine and dandy and I see the dates with the correct Alteryx ISO format 2020-10-26. But they are not, they are in fact strings and whatever I try to make sure they are in a date format in Alteryx is not working I tried datetimeparse([Original Date],'%m/%d/%y'), I tried todate(left([Original Date],4)+"-"+substring([Original Date],4,2)+"-"+Substring([Original Date],6,2)), I tried to use the DateTime tool, it remains a string. It starts to be aggravating since I cannot use a date which is a string in m

Input

Accepted answers

All comments

atcodedog05

Hi @EasyDDI

Can you share some sample data on how your excel date looks.

Qiu

@EasyDDI
Most like the data is the excel is set to text based on my test.

And there might be something off about your parsing format. Check attached workflow.

1028-EasyDDI.yxzp

EasyDDI

Here is the sample data. The field causing me headache is highlighted in yellow 'maturity date'

sample.xlsx

EasyDDI

Thanks. I tried this formula but not like this, I was doing the datetimeparse but was keeping the result in the same column and the formatting was remaining as a string. I think this was the core of my issue.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703