Problem with a column in Date/Time type 1

[Bitaoo]

Hello,

I have a problem that makes me crazy!!! I have a table
with two columns Id as AutoNumber and the othre is
birthDate as Date/Time, there is one record in this
table (1, 1/1/2001)
In VB6 I run this Select statement:

Select * from myTable Where birthData = 1/1/2001

It doesn't return any record (EOF = True)
I tried to run:

Select * from myTable Where birthData = "1/1/2001"

But I got an error "Data type mismatch in criteria expression"
Does any body know what is the problem? Thanks for your help.

--Bita

 

[KornGeek]

Try using #1/1/2001# instead of "1/1/2001".

 

[grobermatic]

Just a small tip, I found when using dates in SQL you must format the date as American... i.e mm/dd/yy

Craig