I've received a csv file where the date filed contains multiple different date formats: dd/mm/yyyy, dd/mm/yy, dd-mm-yyyy, ddmmyyyy. Also silly errors like dd/mm/yyy.
I've resolved most of the errors but I'm looking for a way to fix the rest handful of rows where the date is either:
dd/mm/yyy (digit missing from the year)
Can anybody recommend a nice way to find and fix these fields?