Conversion of mixed dates in DD-MM-YYYY format

[96sudeshnasen]

I have a date column in Excel worksheet but when alteryx reads it, it is read in a mixed format:

DATE:

43602
43617
2019-06-02
2019-06-03
2019-06-09
43619
43619
43644

How to convert all of it to DD-MM-YYYY format?

[fmvizcaino]

Hi @96sudeshnasen ,

Take a look at the example and let me know if that works for you.

Best,

Fernando Vizcaino

[JoeS · Accepted solution]

Hi @96sudeshnasen 

I have used regex to split for formats into different streams, to then parse them into an Alteryx date format.

For the YYYY-MM-DD ones you can use the date time tool.
For the numbers this is how excel stores dates as the number of days since 1900-01-01. So I have used a formula to add the days to that date.

When I then have a Alteryx Date, I can use the formula tool (or date time) to convert to your required format