Date Selection Criteria

Physical Database DDL Statements › DISPLAY/PUNCH ALL Statement › Entity Currency › Date Selection Criteria

Date Selection Criteria

Date selection in these WHERE clause options:

DATE CREATED
DATE LAST UPDATED
DATE LAST CRITICAL CHANGE

may be specified as a value-comparison string in the form 'MM/DD/YY' or 'CCYY-MM-DD' in the right-hand side of the conditional expression and will be interpreted by the extraction in CCMMDDYY form to accurately determine the relationship of dates. For example, these DISPLAY ALL statements:

DISPLAY ALL SEGMENTS
        WHERE DATE CREATED > '01/01/96';

DISPLAY ALL DMCLS
        WHERE DATE LAST CRITICAL CHANGE < '1996-07-14';

establishes a search criteria to identify the occurrences whose date values (which are also evaluated in CCYYMMDD form) meet the requirements of the specified string. The DISPLAY ALL process determines that the date '01/01/96' is greater than the date '12/31/95'.

Alternately, you may specify the value-comparison string on either side of the conditional expression in the form 'CCYYMMDD' to achieve the same results.

You can substitute day, month, or year for each of these WHERE clause options. For example, this DISPLAY ALL statement specifies a search condition which is based on month and year.

DISPLAY ALL AREAS WHERE MONTH CREATED = '01'
                    AND YEAR  CREATED > '95';