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:
Do you know what is happening?Code:
dteDate = this.Date1.Value
WHERE dateInit = "& dteDate &"