Change data type of string to date

[Divyaverma2906]

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

[atcodedog05 · Accepted solution]

Hi @Divyaverma2906 

Here is how you can do it.

Workflow:

Hope this helps : )

[Prashant Chamarty]

If  you are using the datetime building block you will have to specify the format of the incoming string.

You could also use  DateTimeFormat function in the formula building block. => DateTime Functions | Alteryx Help

[Divyaverma2906 · Accepted solution]

👍It works. Thank you much. 😀

[atcodedog05]

Happy to help : ) @Divyaverma2906 

Cheers and have a nice day!