Compare Dates in a SELECT statement

[BirdieNamNam]

Dear friends!

I want to write a SQL statement to retrieve all records matching a certain date. I am writing it in a VB6 project, addressing a ODBC database, created in Microsoft Access. I have tried

SELECT * FROM Bokningar WHERE Bokningar.Date = 2004-03-15

I can see that the date field Bokningar.Date has the format I am using. This does not work. Is there a way to tell all parties to convert the date into some common format, to make comparisions passible? Something like Date(Bokningar.Date) = Date(2004-03-15), or some other way that I cannot imagine?

Thankful for any input.

Bye, Sebastian.

 

[r937]

2004-03-15 is an arithmetic expression equalling 1,986

you want #2004-03-15#

rudy

http://r937.com/

SQL Consulting

 

[BirdieNamNam]

Hehe... aha! Thanks!

Sebastian.