PLS help with date query

[sorucs]

you can use this in ado:

strSQL="SELECT * FROM TableName WHERE dttripstart=#'2000-11-22#

rs.open strSQL,connection,---,---,----