Need to do a comparison on an SQL DATETIME field

Hi,

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

[455 byte] By [Amanda] at [2008-2-5]