Alteryx Designer Desktop Discussions

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

I want to trying to separate date / time into separate Columns

Masond3
8 - Asteroid

Hi Team, 

 

I need some assistance.  

 

I  would like to break out the created date into the following 5 columns

 

CreatedDateYearMonthDateHour Minute
2022-06-10T09:44:15.000+00002022610944

 

Looking forward to your assistance 

 

Many thanks 

2 REPLIES 2
grazitti_sapna
17 - Castor

@Masond3, here is my solution to your problem.

grazitti_sapna_0-1655718669711.png

 

I hope this helps!

 

Thanks!

Sapna Gupta
DataNath
17 - Castor

Hey @Masond3, this is one option. If you don't mind the leading zeros then just remove the Multi-Field Formula at the end:

 

DataNath_0-1655718690178.png

 

Labels