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