Alteryx Designer Desktop Discussions

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

Convert Date from yyyy-MM-dd to yyMMdd

mzlee
7 - Meteor

Hi, I am trying to convert the date from 2023-08-17 to 230817, when I try parsing using DateTime I get a Null output error. 

 

thanks!

 

2 REPLIES 2
ShankerV
17 - Castor

Hi @mzlee 

 

Please use the below formula.

 

DateTimeFormat([Column name],"%y%m%d")

 

Screenshot 2023-08-18 011515.jpg

 

Note: The resultant column should be anything other than Date datatype. 

alexnajm
18 - Pollux
18 - Pollux

Can you share your configuration? The DateTime tool works well - otherwise I might use a Formula and do DateTimeFormat([Date],"%y%m%d")

Labels
Top Solution Authors