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

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.

Workflow

Preparation

Accepted answers

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

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

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

It is Dec 05, 2020.

Could you also send your approach on this?

Thank you.