Changing DateTime format for multiple fields

[ashleyinman]

I have multiple fields that I want to change the datetime format that Alteryx autos to. I have about 10+ different date fields and would like to convert the dates all at once rather than put into multiple tools and I want the output to be a date not a string. 

This is what Alteryx is giving me

Received Date	Ship Date	Promised Date	Scheduled Ship Date
2015-05-09	2015-05-15	2015-06-10	2015-05-20

This is what I want it to look like

Received Date	Ship Date	Promised Date	Scheduled Ship Date
5/9/15	5/15/15	6/10/15	5/20/15

[patrick_mcauliffe · Accepted solution]

You can use the Multi-Field tool. Change the settings at top to allow selection of all text and/or date field types (depending on what your field types are). Then write your date format formula using [Current Field] instead of a field name.
If you have multiple formats you're converting from you could write a conditional formula like "if regex_match([current field],'\d{2}\-\d{2}\-\d{4}') then..."

Alternate method:
Add a RecordID, then Transpose (with RecordID as the key) so that all dates are in a single field. Write a formula for that field and then CrossTab back into the original structure.

[wale_ilori]

I typically do the alternate route. so much more intuitive.