Specifications

62 Searching the Database
ID Works Basic Version 5 Operator’s Guide
Date Fields
The display and entry format for stored search dates is controlled by
the Short date style setting in the Regional Settings Properties
dialog box of the Control Panel. Setting the Short date style to use a
two-digit year may result in a year with a century that is not what the
user expected. To avoid this possibility, select a Short date style
setting that uses a four-digit year.
Possible constraints for Production Form date fields are:
EXACT DATE Constraint Rule
Use the EXACT DATE rule to match an exact date value. Because
time may not be specified for the field but may be stored in the
database, this constraint is turned into a BETWEEN constraint for the
entered date between 00:00:00 and 23:59:59. Example:
where EMPLOYEE.HIREDATE BETWEEN 2000-11-16 00:00:00
AND 2000-11-16 23:59:59
Constraint Rule Required Detail
Supported Options
Exclude Case Insensitive NULL
EXACT DATE A date Yes No Yes
SINCE A date Yes No Yes
BEFORE A date Yes No Yes
BETWEEN Two dates Yes No Yes
PREVIOUS _
DAYS
An integer (1 - 31) No No No
PREVIOUS _
MONTHS
An integer (1 - 12) No No No
IS NULL None No No No
IS NOT NULL None No No No