using date in conditional statement

[locsin]

Greetings!

i am using date in my program. My databasefield <draw_date> declared as shortdate in msaccess.

when i use in the programs

.Open "Select *From numgroup Where Draw_date = '" & DateValue(vdrawdate.Text) & "'", strconek, adOpenStatic, adLockOptimistic

I received error message.. Data Type mismatch in the criteria and sometimes Error 13

Anybody can help to use date as conditional statement..

thank you in advance

[vb5prgrmr]

With the single ticks ' surrounding your date, you are telling the database that you are passing a string. Try removing the single ticks or surrounding the date with # signs.

Good Luck

[debasisdas]

you need to format the input to date for before passing the same to database for processing.