Improve the auto-detection of DateTime when multiple columns are present that need different formats
Check the file attached ExampleFile.B01. The first two columns require different DateTime formats and right now we can either properly read the "Date" column or the "Time" column, the second column will be read as 'Text'.
We should improve our auto-detection logic and try to properly recognize both columns.