Hi,

I am having problems with my vb code finding records in an access 2000 database by date.

does the date format have to be the same in the data base as the one i a using in my code ie

my sql is :-
"SELECT * From LaborDB WHERE Date = #" & strDate & "#"
the date format in strDate is 2/12/2002

in the database the date is 02/12/2002 but the above sql returns that it cannot find it.

I am using a adodb.connection

Thanks for any help

Joolz