WebDocs Home | Show Navigation Hide Navigation

Appendix B: Date and Time Formats

Date display formats supported by ReportWriter

Format name

Format

#01

MM/DD/YYYY

#02

MM/DD/YY

#03

MMDDYYYY

#04

MMDDYY

#05

Mon/DD/YYYY

#06

Mon/DD/YY

#07

MonDDYYYY

#08

MonDDYY

#09

YYYY/MM/DD

#10

YY/MM/DD

#11

YYYYMMDD

#12

YYMMDD

#13

YYYY/Mon/DD

#14

YY/Mon/DD

#15

YYYYMonDD

#16

YYMonDD

#17

DD/MM/YYYY

#18

DD/MM/YY

#19

DDMMYYYY

#20

DDMMYY

#21

DD/Mon/YYYY

#22

DD/Mon/YY

#23

DDMonYYYY

#24

DDMonYY

#25

PP/YYYY

#26

PP/YY

#27

PPYYYY

#28

PPYY

where

MM is the one or twodigit month.

Mon is the threeletter abbreviation for the month.

DD is the one or twodigit day.

YYYY is the year, including the century.

YY is the last two digits of the year.

PP is the period.

The format size and the display size don’t have to match. For example, if you choose a twodigit year format for a field that’s stored as a fourdigit year, ReportWriter automatically omits the century from the display format.

Time display formats supported by ReportWriter

Format name

Format

#01

12:MM

#02

24:MM

#03

12:MMm

#04

12:MM:SS

#05

24:MM:SS

#06

12:MM:SSm

where

12 is the hour in 12hour notation.

24 is the hour in military (24hour) notation.

MM is the minute.

SS is the second.

m is the meridian a or p (ante or post).