date format change in Alteryx

Question

Hello,

I have a date column with date formats not being recognized by alteryx. I want to convert this in the date format, however, there are some dates that are in the correct format and hence I would not want to change those.

In excel I would use the text to column function and select DMY for the wrong dates

would appreciate all the help I can get.

thank you

check only.xlsx

binu_acs · Answer

@murtaza932 Another way of doing this

DateTimeParse_0822.yxmd

Amol_Telore · Answer

Hey @murtaza932

It is called dynamic replace tool. It was installed on my machine by default.

I have added an alternate way for the same. PFA for reference. I have used Multi Field formula tool here as we get option to modify data type of existing field. Only issue with this solution is if there are multiple incorrect date patterns then you will need add those patterns as well in formula tool which is kind of hardcoding whereas dynamic replace tool is more feasible solution since all the conditions and formulas are stored in text file. So it becomes easy for managing the formulas. Hope I have solved your concern.

New Workflow6.yxmd

murtaza932 · Answer

Hi,

Thank you so much for your reply.

The alteryx designer version I have is an older version hence I am not able to import it, but by looking at the workflow I am not sure which function is not on my alteryx