datetime dates converted to wrong date when Imported from csv file

[Suzy_Cat]

Hi Patrick,

Your advice is very thorough and definitely addressed my concern. You have pointed me to the right direction. The detailed info for sure will help me to understand the deep root cause. 🙂
It will take me a while to go through all the readings and I enjoy the learning curve on the right journey.

I really appreciated your patience. I struggled to describe the issue and almost gave up, had thought I won't be able make it clearer for people to understand where I was stuck.

Thank you sincerely.

[Suzy_Cat]

Thanks @Patrick! That worked like a charm.
I have tested and now have full control. The data quality issue resolved perfectly.

So just choose the right option relevant to date format in the CSV file 🙂

OPTIONS DATESTYLE= MDY | YMD | DMY | LOCALE