I am using ODBC/vb 6 to access a dbase system and need to do a date selection, but keep getting various errors including
- Data type mismatch in criteria expression
, Collating sequence not supported. I think it is to do with the date literal but haved tried all of the following.

the datefield is a date type

ConnectionString = "Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=C:\\files\\dbase;"

datefield >= '01/12/2002' ..
datefield >= '2002-12-01' ...
datefield >= "01.12.2002' ...
and even ODBC escape sequence
datefield > = {d '2002-12-01'}

Any hint appreciated

PS regional settings are UK

Daniel