comparing dates

[tonyjob]

im getting a data type mismatch error when i try to compare a date from a text box with a date in a access db, the field in the db is set to short date. im using the following sql statment.

"select * from [members] where [date]= '" & text1 & "';"

db date: 21/01/2001
textbox date: 21/01/2001

i cant see any reason why it doesnt work.

any ideas?

 

[dsi]

Make sure the date from the textbox is formatted as a date, not text.

 

[tonyjob]

how do i do that? move into another variable before comparing it?

 

[edderic]

"select * from [members] where [date]= #"

& Format(text1,"mm/dd/yyyy&quot & "#"
Eric De Decker
vbg.be@vbgroup.nl

Licence And Copy Protection AxtiveX
Source CodeBook for the programmer

http://www.createsoftware2000.com