In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

DateTime Transformation

luo
8 - Asteroid

Hello guys,

 

I want to convert sting field to datetime. However, the data is not formated. For example, the format of the string field should be MM/DD/YYYY. But actuallly, the 12/31/2018 is good, the 01/31/2018 will be like 1/31/2018 as the table shows below: 

 

11/7/2019
12/17/2019
9/21/2019
10/21/2019

 

Is there a way to convert to datetime as YYYY-MM-DD? Thank you guys. 

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@luo 
I dont think that will be an issue for DateTime Tool 😁

Capture1.PNG

luo
8 - Asteroid

yeah...

Labels
Top Solution Authors