Alteryx Designer Desktop Discussions

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

Inconsistent Date String Format

cynthiapan
5 - Atom
I have a column of dates where the string format is %m%d%Y. However, if the month or day is a single digit, the 0 is removed. For example, March 4, 2020 would be in the format of 342020. How do I turn 342020 into a date format?
1 REPLY 1
fmvizcaino
17 - Castor
17 - Castor

Hi @cynthiapan ,

 

Unfortunately, there isn't a way of doing that automatically. 

For example, 1122020 could be 11-02-2020 or 01-12-2020. 

 

Is there any other column that could help you into finding out the correct format?

Best,

Fernando Vizcaino

Labels