Handling dates in queries

[mrk68]

Hi,

I am trying to retrieve records from access mdb based on the date entered by the user. I am getting a type mismatch error for the select statement :

strdate = CDate(Me.txtRequestDate)



Set DBRecSet = dbs.OpenRecordset("select * from DBReq where RequestDate= # strdate #")

I think the problem lies in the where clause. But I am unable to rectify this. Any pointers ?

Thanks in advance,
mrk68

[RuralGuy]

Try:
Set DBRecSet = dbs.OpenRecordset("select * from DBReq where RequestDate= #" & Me.txtRequestDate & "#")

[rommelgenlight]

or since you have set your strdate, try removing "#" on your criteria.

[mrk68]

I got it working. I removed # in my criteria. Thanks.

[RuralGuy]

Excellent! Glad to hear you got it working.