Multi Field Formula to Change Multiple date fields

Question

I have a number of fields (10+) in my data that are in needing of conversion to a date type. Currently they're in a format of DD/MM/YYYY and are reading in as a string. If I convert the data type using a Select Tool, Alteryx is reading the day/month incorrectly.

I'm hoping I can use the Multi Field formula and the DateTimeParse function (?) to convert all of these fields using 1 tool.

Sample Data is attached! Appreciate any help here!!

Date Data for Alteryx.xlsx

grossal · Accepted Answer

Hi @MelShank,

you could use the Multi-Field-Formula and DateTimeParse Function to achieve this. (Multi-Field Formula so you can have as many columns as you want)

Configuration:

I noticed that you have two separate date formats, so I used an IF THEN ELSE to parse both types correctly.

Output:

Workflow attached. Let me know if this solved your problem 😃

Best

Alex