Valid date formats

Valid date formats

Board standard time entities accept the following date formats,

 

Entity

Width

Format

Example

 

Day

Day

Day

Day

Day

Week

Week

Week

Week

Week

Week

Week

 

Month

Month

Month

Month

Month

Month

Bimonth

Bimonth

Bimonth

Bimonth

Bimonth

 

 

Bimonth

Bimonth

Bimonth

Bimonth

Bimonth

Quarter

Quarter

Quarter

Quarter

Quarter

Quarter

Quarter

Quarter

Year

Year

 

6

6

7

8

8

4

4

5

5

6

6

7

 

4

4

5

5

6

6

3

3

4

4

4

 

 

5

5

5

6

6

3

3

4

4

5

5

6

6

2

4

 

DDMMYY

YYMMDD

MMMDDYY

DDMMYYYY

YYYYMMDD

WWYY

YYWW

WW?YY

YY?WW

WWYYYY

YYYYWW

MMMDDYY

 

MMYY

YYMM

MM?YY

YY?MM

MMYYYY

YYYYMM

BYY

YYB

BBYY

YYBB

XYYY

 

 

XY?YY

BYYYY

YYYYB

BBYYYY

YYYYBB

QYY

YYQ

QQYY

YYQQ

QYYYY

YYYYQ

QYYYY

YYYYQQ

YY

YYYY

 

311204

041231

DEC3104

31122004

20041231   recommended

4804     (forty-eighth week of 2004)

0448

48-04

04-48

482004  

200448   recommended

DEC3104   (last day of week; the Day entity

must be enabled)

1204

0412

12-04

04-12

122004

200412   recommended

204   (second Bimonth 98)

042

0204

0402

MA04    (X-Y indicate the initials of the

            Month included in the Bimonth-

            March April)

MA.04

22004

20042

022004

200402   recommended

104       (first quarter 98)

041

0104

0401

12004

20041

012004

200401   recommended

04

2004   recommended