Specifications

Searching the Database 63
ID Works Basic Version 5 Operator’s Guide
Exclude Option
If you select Exclude constraint detail, the search will match any
date other than the one you entered. It applies an SQL NOT to the
constraint. Example: where EMPLOYEE.HIREDATE NOT
BETWEEN 2000-11-16 00:00:00 AND 2000-11-16 23:59:59
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain the date you
entered. Example: where ((EMPLOYEE.HIREDATE BETWEEN
2000-11-16 00:00:00 AND 2000-11-16 23:59:59) OR
(EMPLOYEE.HIREDATE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
SINCE Constraint Rule
Use the SINCE rule to match any date greater than the entered date
(that is, going forward in time). Because time may not be specified for
the field but may be stored in the database, the time 23:59:59 is
added to the date. Example:
where EMPLOYEE.HIREDATE > 2000-11-16 23:59:59
Exclude Option
If you select Exclude constraint detail, the search will match any
date less than or equal to the one you entered. Example:
where EMPLOYEE.HIREDATE <= 2000-11-16 23:59:59
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain dates greater
than the date you entered. Example:
where ((EMPLOYEE.HIREDATE > 2000-11-16 23:59:59) OR
(EMPLOYEE.HIREDATE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.