Convert Date from yyyy-MM-dd to yyMMdd

[mzlee]

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!

[ShankerV · Accepted solution]

Hi @mzlee 

Please use the below formula.

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

 

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

[alexnajm]

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