String to date using Multi Field Formula

[KateC]

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!

[atcodedog05]

Hi @KateC 

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

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

Workflow:

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

Hope this helps : )

[Maskell_Rascal · Accepted solution]

Hi @KateC 

Here is how you can do it. 

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

Let me know if this solution works for you. 

Cheers!

Phil

[messi007]

@KateC,

Please see below:

Attached the worklow.

Hope this helps !

Regards

[KateC]

Thanks, Maskell Rascal! That worked perfectly.