Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Convert String To Date

RichardAlt
8 - Asteroid

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!

3 REPLIES 3
Nanoq
8 - Asteroid

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
22 - Nova
22 - Nova

Hi @RichardAlt 

 

Use formula like below

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

 

Workflow:

atcodedog05_0-1633951868662.png

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @RichardAlt 

 

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

 

Workflow:

atcodedog05_0-1633952280480.png

 

Hope this helps : )

Labels