Hi all,
I have a critical challenge with a date column where it has multiple date formats randomly inserted in the records.
I need to display them in the right format 'YYYY-MM-dd' in a single output date column.
How do I get this possible?
Best,
Teja.
Solved! Go to Solution.
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