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!
Hi @RichardAlt
You can get the exact output by following the below method.
Workflow:
Hope this helps : )
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%yMeaning your full formula (assuming your input string is [Field1]) would be:datetimeformat(DateTimeParse([Field1],"%d%b%y"),"%m/%d/%Y")
Use formula like below
DateTimeFormat(DateTimeParse([Date],"%d%b%Y"),"%m/%d/%Y")
