Changing multiple columns to dates without using multiple date tools.

[jbh1128d1]

I have a data set with multiple date-string columns.  Is there some type of parameter control that will allow me to run all of the columns through to change to a date without using 10 or 20 DateTime parse tools?  

[Kenda]

Hey @jbh1128d1! Try this macro that is a spin off of the normal DateTime Parse tool. 

[LordNeilLord · Accepted solution]

Hi,

The multifield tool can solve this problem:

[LordNeilLord]

I forgot about the time element....

This is the correct formula for the multifield tool:

DateTimeParse(REGex_Replace([_CurrentField_],"Z|T"," "),'%Y-%m-%d %H:%M:%S')

[jbh1128d1]

Thank you Bolide.  That's clever.

[DataMeister]

Everyone: I can't believe my search turns up a manual solution from 2018 and it's now 2024! Why hasn't this basic need been automated? Now I have to paste a messy formula with RegEx arcane-ness into a tool, when Alteryx should make date handling effortless? Even thinking about date handling should be a thing of the past!