Date parsing

[elfunambolo]

I have an error in parsing date. In excel file the cells in the column Actual Start date are formatted as date but when I import the data in Alteryx are considered string. I tried to use Date parsing formula to convert it but I have errors.

Can you support me?

Thanks

Giovanni

[JosephSerpis]

Hi @elfunambolo your formula is nearly correct you are missing the slashes as you need to match your format of the data for that formula to work. The dates are being recognised as string as Alteryx date formats need to be in ISO format e.g. YYYY-MM-DD. You can find out more from this documentation.

[elfunambolo · Accepted solution]

Ok, now no errors happened but the column is still V_string type not Date, why?

Regards,

Giovanni

[JosephSerpis · Accepted solution]

Hi @elfunambolo in a formula tool you can't change an existing datatype hence in my previous post in the screenshot the dropdown is greyed out. There a few ways you can tackle this. You use create a new column with a date data type or use Multi-field tool which is the only formula tool in alteryx that can change an existing field data type. Or you could be a select tool and changed the data type to a date like I've done in this screenshot.

[binay2448 · Accepted solution]

You can also use DataTime tool to do the same, find attached.