Specifications

74 Searching the Data Source
ID Works Standard and Enterprise Version 5 Operator’s Guide
where EMPLOYEE.HIREDATE NOT BETWEEN 1995-11-11
00:00:00 AND 1995-12-31 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 between
the dates you entered. Example: where ((EMPLOYEE.HIREDATE
BETWEEN 1995-11-11 00:00:00 AND 1995-12-31 23:59:59) OR
(EMPLOYEE.HIREDATE IS NULL))
You can use the Include NULL values option with the Exclude
constraint detail option.
PREVIOUS _ DAYS Constraint Rule
This constraint offers a relative date. When you open the search, the
starting date is calculated as Current Date - x Days where x is the
Constraint value you entered (from 1 to 31). Because time may not
be specified for the field but may be stored in the database, this rule
expands to use a > clause with time set to 00:00:00. Example: (query
opened on March 17, 2000, with Constraint value set to 1)
where CARD.ISSUEDATE > 2000-03-16 00:00:00
No options are available with the PREVIOUS _ DAYS constraint rule.
PREVIOUS _ MONTHS Constraint Rule
This constraint offers a relative date. When you open the search, the
starting date is calculated as the same day x months ago where x is
the Constraint value you entered (from 1 to 12). If the current day
does not exist in the starting month, the highest valid date for the
month is used. Because time may not be specified for the field but
may be stored in the database, this rule expands to use a > clause
with time set to 00:00:00. Example: (query opened on March 31,
2000, with Constraint value set to 1)
where CARD.ISSUEDATE > 2000-02-29 00:00:00
This behavior matches the operation of the Windows Explorer Find
File function.
No options are available with the PREVIOUS _ MONTHS constraint
rule.