These examples are provided to illustrate the use of the date format/range rule:
Description of Check Required | Date Format | Days Into Past | Days Into Future |
|---|---|---|---|
Check column DATDUE is in format DDMMYY | DDMMYY | 9999999 | 9999999 |
Check column DATDUE is in format YYMMDD and is not prior to the current date. | YYMMDD | 0 | 9999999 |
Check column DATE is in format DDMMYYYY and is within the next 90 days. | DDMMYYYY | 0 | 90 |
Check column DATE is in format DDMMYY and is in the last 180 days. | DDMMYY | 180 | 0 |
Check column DATE is in format YYYYMMDD and is in the last week. | YYYYMMDD | 7 | 0 |
Check column DATE is in format YYYYDDMM and is within the next week. | YYYYDDMM | 0 | 7 |
Check column DATE is in format YYMM. | YYMM | 9999999 | 9999999 |
Check column DATE is in format MMDDYYYY and is within the next 30 days. | MMDDYYYY | 0 | 30 |