Invalid Date Error
Working in FlySpeed 3.3.1.9.
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:
Select
"quikagtb08312016.dbf".MAGENT,
"quikagtb08312016.dbf".MSTMTDATE,
"quikagtb08312016.dbf".MAGTBAL
From
"quikagtb08312016.dbf"
Where
"quikagtb08312016.dbf".MSTMTDATE = '01/31/2016'
Order By
"quikagtb08312016.dbf".MSTMTDATE Desc
Hi,
Please try the new version. Let me know if the problem still persists on your side.