Specifications

Searching the Data Source 73
ID Works Standard and Enterprise Version 5 Operator’s Guide
BEFORE Constraint Rule
Use the BEFORE rule to match any date less than the entered date
(that is, going backward in time). Because time may not be specified
for the field but may be stored in the database, the time 00:00:00 is
added to the date. Example:
where EMPLOYEE.HIREDATE < 2000-11-16 00:00:00
Exclude Option
If you select Exclude constraint detail, the search will match any
date greater than or equal to the one you entered. Example:
where EMPLOYEE.HIREDATE >= 2000-11-16 00:00:00
NULL Option
If you select Include NULL values, the search will return all records
with NULL values in addition to records that contain dates less than
the date you entered. Example: where ((EMPLOYEE.HIREDATE <
2000-11-16 00:00:00) OR (EMPLOYEE.HIREDATE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
BETWEEN Constraint Rule
Use the BETWEEN rule to find records with dates between two
bounding dates (and including the bounding dates). The Constraint
value must have a date earlier than Ending constraint value. To
search for dates in the future, set the Ending constraint value first
and then the Constraint value. Because time may not be specified
for the field but may be stored in the database, the time 00:00:00 is
added to the date you enter in Constraint value and 23:59:59 is
added to the date you enter in Ending constraint value. Example:
where EMPLOYEE.HIREDATE BETWEEN 1995-11-11 00:00:00
AND 1995-12-31 23:59:59
Exclude Option
If you select Exclude constraint detail, the search will return all
records with dates outside the bounding dates you entered. It applies
an SQL NOT to the constraint. Example: