Previous Topic: Date Format PatternNext Topic: Delimiters

Introduction › Override the Preferred Date Pattern › Separators

Separators

The following table shows how separators are used to format dates.

Separators

Examples

Results

period (.)

DDMMM.YYYY

01JUN.2005

slash (/)

YYYY/DDD

2005/152

dash (-)

MM-DD-YYYY

06-01-2005

comma (,)

MMMDD,YYYY

JUN01,2005

space ( )

DD MM YYYY

01 06 2005

The last entry under Results (01 06 2005) illustrates the importance of using the proper format to enter dates. The date format tells CA 1 whether to process 01 06 2005 as January 6, 2005 or June 1, 2005.