Download DataCard UltraGrafix Magna Specifications

62
Searching the Database
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:
Supported Options
Constraint Rule
Required Detail
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
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
ID Works Basic Version 5 Operator’s Guide