HELP NEEDED: Date Format Change

[yuchanliu88]

I have a date column formatted as "mm/dd/yyyy", such as "8/3/2021". I need it to be in the TRUE "mm/dd/yyyy" format, such as "08/03/2021". In addition, there are some null records with no value at all. I would like to keep it blank. Can anyone help me to resolve this issue? Thank you very much for your help. 

[KarolinaRoza · Accepted solution]

hi @yuchanliu88 

Once you convert "8/3/2021" to Alteryx data type format, you can apply Formula tool to change to "mm/dd/yyyy" by:

DateTimeFormat([DateTime_Out],"%m/%d/%Y")

what is more, null values will stay null as well.

Karolina

[Jotigautam · Accepted solution]

Not sure if by blank you mean empty or null cell so here is a way to do that if need to keep empty, otherwise remove if statement..

[yuchanliu88]

Hi Karolina,

Thank you so much for your time and help. It worked!

Have a nice one.

Yuchan

[yuchanliu88]

Thank you very much for your help! Very helpful:)

Yuchan