How to format irregular dates present in a single date column to a YYYY-MM-dd format.

[stj1120]

Hi all,

I have a critical challenge with a date column where it has multiple date formats randomly inserted in the records. 

Input dates-Multiple formats

I need to display them in the right format 'YYYY-MM-dd' in a single output date column.

Output dates inYYYY-MM-dd format

How do I get this possible?

Best,

Teja.

[ChrisTX]

I've worked with data like this before and have a few ideas.

How would you determine the correct value when an incoming row may be converted to a valid date using two separate logic options?

12.05.2020

05.12.2020

These two dates could be December 5 or May 12.  Which date would you choose?

Chris

[CarliE · Accepted solution]

I solved this by doing a formula. It is attached. This may have to be adjusted based on the comment Chris brought up.

[stj1120]

Hi @ChrisTX 

It is Dec 05, 2020. 

Could you also send your approach on this?

Thank you. 

[CarliE]

Hi @SR ,

Looks like my solution above solved for that 🙂 

Have a nice weekend!