[Zope] Invalid Date-Time String in ODBC

[Steve Alexander]

Ali Baitam wrote:
> 
> I have an Access table with a date/time field. The field
> had date and time info (12/4/1999 14:00AM). I made an SQL
> Method on this table (through ODBC connection) but the test
> returned "Invalid Date-Time String". I removed the time
> portion in all the records but the error persisted.
> 
> Any idea?

12/4/1999 is ambiguous. In the US, it means December 4th, in the UK it
means April 12th.

See the comments at the start ot the source of DateTime.py for more
explanation.

--
Steve Alexander
Software Engineer
Cat-Box limited