Alteryx Designer Desktop Discussions

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

Convert string date time to Alteryx recognized date/Time format

AbdulBasit
8 - Asteroid

Alteryx date.PNG How do i convert this string date time to Alteryx recognized date time. I have used date time tool  but it gives a NuLL Column. Please Help

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

You can try below formula to convert to datetime.

 

DateTimeParse([order date],"%m/%d/%Y %H:%M")

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Hi @AbdulBasit 

 

Here is a workflow example.

 

atcodedog05_0-1629377321255.png

 

Hope this helps : )

 

Emil_Kos
17 - Castor
17 - Castor

Hi @AbdulBasit,

 

This is the formula that you need:

 

DateTimeParse([Field1],'%m/%d/%Y %H:%M')

 

Workflow:

 

Emil_Kos_0-1629377255394.png

Output:

Emil_Kos_1-1629377262249.png

 

Labels