Invalid Date Error

Avatar
  • updated
  • Completed

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


Avatar
Anonymous

Hi,

Please try the new version. Let me know if the problem still persists on your side.