Icon View Incident Report

Minor Minor
Reported By: Jeremy Martin
Reported On: 1/6/2005
For: Version 4.16 Build 1
# 1940 Using Date/Time/Timestamp Constant As First Argument to BETWEEN and IN Operators in SQL Causes Error

The following SQL statement generates the error:

#11949 SQL parsing error - Expected NULL, FixedChar, GUID, String,
Memo, or BLOB expression but instead found startdate in SELECT SQL
statement at line 2, Column 26

select * from placemnt where key = 'MURPHYJORD'
and '2005-01-06' between startdate and enddate

Comments Comments and Workarounds
The workaround is to specifically CAST() the date/time/timestamp constant like this:

CAST('2005-01-06 AS DATE) BETWEEN StartDate AND EndDate

Resolution Resolution
Fixed Problem on 1/6/2005 in version 4.17 build 1