You are here: LANSA for i User Guide > 2. Fields > 2.12 Date Format / Range Rule > 2.12.1 Examples

2.12.1 Examples

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 field DATDUE is in format DDMMYY

DDMMYY

9999999

9999999

Check field DATDUE is in format YYMMDD and is not prior to the current date.

YYMMDD

0

9999999

Check field DATE is in format DDMMYYYY and is within the next 90 days.

DDMMYYYY

0

90

Check field DATE is in format DDMMYY and is in the last 180 days.

DDMMYY

180

0

Check field DATE is in format YYYYMMDD and is in the last week.

YYYYMMDD

7

0

Check field DATE is in format YYYYDDMM and is within the next week.   

YYYYDDMM

0

7

Check field DATE is in format YYMM.

YYMM

9999999

9999999

Check field DATE is in format MMDDYYYY and is within the next 30 days.

MMDDYYYY

0

30