[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?