When you get data with multiple date formats in same column, it may result errors while transforming the Data.
I have noticed that many business data users are clearing those errors manually, which may cause delay in final report creation / inaccurate results !
In this video I have explained how to transform such columns where multiple date formats are placed and resulting errors while transforming the data!