I have a text file with Date and Time fields containing the values 01/01/2020 and, for the time field, 13:00:22
In Microsoft Query the values show as 2020-01-01 00:00:00 and 1899-12-30 13:00:22
When returned from MS Query to appropriately formatted columns in a Query Table they show as 01/01/2020 and 00:00:00
However, if I create a DateTime field as Date+Time it shows as 01/01/2020 13:00:22
How to get the Time to show correctly in the Query Table?
Time + 2 as [Time]
This shows as 13:00:22 in the Query Table. Took me ages to figure this out. I spent ages playing around with the DateTimeFormat option in the Schema.ini to no avail. It seems that if MS Query returns anything prior to 01/01/1900 00:00:00 the time portion will always show as 00:00:00 in Excel