Inconsistent Date String Format

[cynthiapan]

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?

[fmvizcaino · Accepted solution]

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