Hint needed to reshape input data with bad data maintenance and data quality

I put your two values in and converted it to a Date column (click on the abc123 and choose Date), and it worked.  Have you tried that already?  When you do that, any that don't work will show as "Error".  Please share those values  (click to the right of the word Error to see the original value below the preview), to get specific suggestions.

For now, I would work toward improving the data validation on your source, if possible.

Pat

Hi mahoneypa,

thank you for this suggestion, it worked perfectly

(Note to myself: Being more "experimental" helps!)

Nevertheless the way of data-maintenance and -governance is still to discuss with responsible departments...

Once againt

hank you very much!

Thomas