Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

how to get the data to datetime format

WuCong
8 - Asteroid

I have one data, format is I want to get the date part and time part and to change to datetime format ?

I found 01JAN2022 is not a standard date format.

2 REPLIES 2
rajeshkannanr
Alteryx
Alteryx

Hi Wu,

 

Greetings!

 

Thank you for reaching out to us. Here is the high-level overview of converting the column to DateTime format.

 

  1. Split the column as Date and Time using the substring function.
  2. Split the Date columns as Day, Month and Year.
  3. Merge the columns Day, Month, and Year as separated by "-"
  4. Finally, Merge Date and Time columns separated by space.

 

I have attached a screenshot of my transformer for your reference.

 

Regards,

Rajesh.

WuCong
8 - Asteroid

thank you?Rajesh