I am getting a "Data type mismatch in criteria expression" error when trying the following SELECT statement.
strdt and spdate are Date types in my vb codebehind and the Contract field name is a DateTime field.
thanks for your help
DimnmxSQL As String = "SELECT * FROM Nymex WHERE (NymexID='" & nymID & "' And Contract>='" & strdt & "' And Contract<='" & spdate & "')"
View Complete Post