What is the syntax for a select statement with date?

I have the following select statement and I am getting a syntax error. The database is Oracle 8.i

mysql = "SELECT * FROM dbo.Member_Custom_Acct where Member_ID = " & rsActive("Member_ID") '& " AND Date_01 < '01/01/2006'"

I am trying to get all records that has a date older than 01/01/2006.

Thanks

Try the ISO standard date format: YYYY-MM-DD H24:MI:SS

- A.Kahtava

did u sort it

the problem is a wrong VB syntax, not in the select statement. If that was a case, you should have got a database error when running the code.

There is a ' sign before the last & that needs to be removed :

'& " AND Date_01 < '01/01/2006'"

I would write like this, enclosing rsActive within ''

mysql = _
"SELECT * FROM dbo.Member_Custom_Acct where Member_ID = '" & _
rsActive("Member_ID") & _
"' AND Date_01 < '01/01/2006'"

Marco