File does not always recognize datetime from Google Sheets, and, in such cases, won't allow reinterpretation of text as datetime.

[wvdvegte]

What's wrong?
File does not always recognize datetime from Google Sheets, and, in such cases, won't allow reinterpretation of text as datetime.

How can we reproduce the problem?
Put a File widget on the canvas, and put the following link in the URL field: https://tinyurl.com/5xsaaywz (or https://docs.google.com/spreadsheets/d/1bWFTDeoOZ8qOc18OrprhhuHemgLolV8N0RG601j52zw/edit?gid=644664737#gid=644664737, which is what the short link refers to).
The datetime "End of Ride" is properly ISO formatted, but as Type, only text and categorical can be selected.
It can be changed to datetime with Edit Domain downstream, though

What's your environment?

• Operating system: Mac OS 15.3
• Orange version: 3.38.1

[processo]

It is the truncated hour format (e.g. 8:03:00) that causes the problem. ISO 8601 deprecated the truncated formats and requires 2 digit hours with leading zeros.

It is unrelated to Google Sheets. Even this small CSV breaks it:

serial number	distance	End of ride
3.12325426673749E+016	3.69257	2018-05-27 8:03:00

[wvdvegte]

@processo, Thanks for pointing that out! The funny thing is that the csv file from which I copy-pasted the data into Google Sheets did contain hours with leading zeros, so in a sense it is related to Google Sheets. Very frustrating how spreadsheet software such as Sheets and also Excel like to take formatting decisions on their own.
And fortunately Edit Domain can still handle truncated hour notations.