Hi,

I am using VB6 with a Microsoft Access ODBC database back end.

I have a date within a particular table, formatted as dd/mm/yyyy (UK Format)

When using a SQL query I do the following


SELECT * FROM SOMETABLE WHERE MYDATE = 14/02/2000




The database returns zero records even though I know that records are present which meet this criteria. I have tried different formats but with no luck

Can anyone help?

TIA

Ian