Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Changing multiple columns to dates without using multiple date tools.

jbh1128d1
10 - Fireball

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?  

4 REPLIES 4
Kenda
15 - Aurora
15 - Aurora

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

LordNeilLord
15 - Aurora

Hi,

 

The multifield tool can solve this problem:

 

Multifield.PNG

LordNeilLord
15 - Aurora

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
10 - Fireball

Thank you Bolide.  That's clever.

Labels