Convert String To Date

[RichardAlt]

Hi All,

How to convert this string "01JUL21"  to  7/1/2021 (m/d/yyyy). I've already try this formula "DateTimeParse([MyDate],"%m%d%y")" and I got Null value. 

Thank you!

[Nanoq]

The easiest way is to use the datetime tool, in that case your custom string is "ddMonyy" 
if you want to use datetimeparse, the string is %d%b%y
Meaning your full formula (assuming your input string is [Field1]) would be:
datetimeformat(DateTimeParse([Field1],"%d%b%y"),"%m/%d/%Y")

[atcodedog05]

Hi @RichardAlt 

Use formula like below

DateTimeFormat(DateTimeParse([Date],"%d%b%Y"),"%m/%d/%Y")

Workflow:

Hope this helps : )

[atcodedog05 · Accepted solution]

Hi @RichardAlt 

You can get the exact output by following the below method.

Workflow:

Hope this helps : )