%DATE Input Formats

ELEMENT

DESCRIPTION

EXAMPLES

DAYS

1 or 2 digits

1,01,24

MONTHS

1 or 2 digits

3,03,12

Abbreviations accepted

MAR

Numeric months precede days

1/5 is 5 Jan

Alpha months may precede or follow days

3 MAR MAR 3

YEARS

2 or 4 digits

11/22/98

11/22/2002

A missing year defaults to current year

11/22

TODAY

Abbreviation accepted

T[ODAY]

t+/- N. no. of days

t+1

t-3

TOMORROW

Abbreviation accepted

TOM[ORROW]

YESTERDAY

Abbreviation accepted

Y[ESTERDAY]

NULL INPUT

Defaults to today

DELIMITERS

All non-alphanumeric character(s) except the + or - offset

11/22/98

11 Nov 98

22 Nov, 2002

11-22-2002