Figure 4: Correct Date Format with “dd/mm/yy” British/French date style Example 2: Sometimes, string-to-date conversion in SQL Server results in an error, not because of the date or time formats used, ...

Yes this is an issue. However, easy workaround is to set the date format on the cell to yyyy-mm-dd and then read the cell. It works for me.

With a format of dd MMM yyyyy however - what should happen if a user types in 05/01/2019 or (even 05 01 2019). At the moment this is parsed as MDY - so we end up with the 1st May.