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

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