Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

String to date using Multi Field Formula

KateC
8 - Asteroid

Hello,

 

I have two columns with dates formatted like this: 01.02.20 (MM.dd.yy) with data type string.  I need to convert them to MMddyyyy. Seems like Multi Field Formula would be the easiest way to do this but I can't figure it out.  Any advice? Thanks!

4 REPLIES 4
atcodedog05
22 - Nova
22 - Nova

Hi @KateC 

 

You can do something like this. Just remove the "." inbetween.

 

 

Replace([_CurrentField_], ".", "")

 

 

 

Workflow:

atcodedog05_0-1628602999060.png

 

Edit : Guess i missed out that year was needed in yyyy format 😅

 

Hope this helps : )

Maskell_Rascal
13 - Pulsar

Hi @KateC 

 

Here is how you can do it. 

DateTimeFormat(DateTimeParse([_CurrentField_],'%m.%d.%y'),'%m%d%Y')

Maskell_Rascal_0-1628603035427.png

 

Let me know if this solution works for you. 

 

Cheers!

Phil

messi007
15 - Aurora
15 - Aurora

@KateC,

 

Please see below:

 

messi007_0-1628603198088.png

 

Attached the worklow.

 

Hope this helps !

 

Regards

KateC
8 - Asteroid

Thanks, Maskell Rascal! That worked perfectly.

Labels
Top Solution Authors