Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

How to convert datetime with "T" Separator

mark_paul
8 - Asteroid

Hi,

 

How to convert below string into date time format?

 

2019-07-08T17:16:25.000 to 2019-07-08 17:16:25

5 REPLIES 5
RishiK
Alteryx
Alteryx

Hey

 

Very easy with the DateTime parse tool as attached.

JosephSerpis
17 - Castor
17 - Castor

Hi @mark_paul you can do it with the DateTime toolDatetime.JPG

mark_paul
8 - Asteroid

Hi Rishik,

 

I am not able to see the solution, my alteryx version is 2018.4.5.

 

Thanks,

Mark

RishiK
Alteryx
Alteryx

Snapshot attached

mark_paul
8 - Asteroid

Thank you Rishi

Labels