Change data type of string to date

Question

Column has both date and General word format date (44350). when I import the data in Alteryx my data gets converted in String, the numbers are now appearing as text and when I change the format of date column using date parse tool, text results in blank value.

Attached is the sample excel file

Sample Date data.xlsx

atcodedog05 · Accepted Answer

Hi @Divyaverma2906

Here is how you can do it.

Workflow:

Hope this helps : )

Divyaverma2906 · Accepted Answer

👍It works. Thank you much. 😀