Invalid Date Error
Working in FlySpeed 184.108.40.206.
3GB .dbf file.
Attempting to select records in database by date. Field name MSTMTDATE is recognized as a DATE. Its formatting is mm/dd/yyyy.
For the MSTMTDATE field, when I enter criteria of = '01/31/2016' (for example), I get error:
"Error 7200: AQE Error: State = S0000; NativeError = 2124; [iAnywhere Solutions] [Advantage SQL Engine][Invalid operand for operator: = [Invalid DATE] -- Location of error in the SQL statement is: 161"
Here's the whole query: