I am creating a pipeline where the source is csv files and sink is SQL Server.
The date column in CSV file may have following values like
12/31/2020 10162018 20201017 31/12/1982 1982/12/31
I do not find the function which checks the format of the date.
How do I check the format and convert the above values to