problem with date field

[Ed]

I want to filter a record in a table of SQLServer2000, the dateInit field is the primary key, but It doesn't work the CONVERT function because the record doesn't filter it, that is to say: the record doesn't find it.
I do the where like this:

Code:

Date dteDate
dteDate = this.Date1.Value
 
WHERE dateInit = "& dteDate &"

Do you know what is happening?

[Peter]

Quote:

WHERE dateInit = "& dteDate &"

You have to put a simple Quotation mark (‘)and finish the concatenation of the var with the query

[bbq]

Don't assign to a variable, it's better if you put the content of the control literal (this.Date1.Value) between #

WHERE dateInit = #"& dteDate&"#"