| 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
|
