date format change in Alteryx

[murtaza932]

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

[Qiu]

@murtaza932 
We can seperate the data stream first then use the DateTime tool to parse the incorrect format to DateTime format of alteryx.

[Amol_Telore]

Hey @murtaza932 

Here is an another way of doing the same. If you have multiple date patterns occurring, you can update those patterns in the text file.

[murtaza932]

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

[Amol_Telore]

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.

[binuacs]

@murtaza932 Another way of doing this