WHERE DEFER_STARTDTE <= '01/11/1996'
and the DEFER_STARTDTE field is a DateTime field. When I attempt to run the above query I get a 'Data type mismatch in criteria expression'.
Do you I need to convert my string '01/11/1996' to a DateTime value since the field is also a DateTime value and if that's the case, what's the syntax for changing the data type of the expression. Is it also similar to the SQL Server CONVERT and CAST functions?