Need to do a comparison on an SQL DATETIME field
Quick question: I need to know the syntax for comparing a DATETIME field in a SQL database to a control variable in Visual Basic. Here's the psuedocode:
If Row.ControlField <> ControlVar Then
Where
Row.ControlField = a SQL DATETIME Field
and
ControlVar = a variable that is compliant with DATETIME
1. How/what data type do I declare the ControlVar?
2. What is the correct syntax for the comparison?
Thanks,
Amanda

