Appendix B: Date and Time Formats

Date display formats supported by ReportWriter

Format name

Format

#01

MM/DD/YYYY

#02

MM/DD/YY

#03

MM-DD-YYYY

#04

MM-DD-YY

#05

Mon/DD/YYYY

#06

Mon/DD/YY

#07

Mon-DD-YYYY

#08

Mon-DD-YY

#09

YYYY/MM/DD

#10

YY/MM/DD

#11

YYYY-MM-DD

#12

YY-MM-DD

#13

YYYY/Mon/DD

#14

YY/Mon/DD

#15

YYYY-Mon-DD

#16

YY-Mon-DD

#17

DD/MM/YYYY

#18

DD/MM/YY

#19

DD-MM-YYYY

#20

DD-MM-YY

#21

DD/Mon/YYYY

#22

DD/Mon/YY

#23

DD-Mon-YYYY

#24

DD-Mon-YY

#25

PP/YYYY

#26

PP/YY

#27

PP-YYYY

#28

PP-YY

where

MM is the one- or two-digit month.

Mon is the three-letter abbreviation for the month.

DD is the one- or two-digit 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 two-digit year format for a field that’s stored as a four-digit 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 12-hour notation.

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

MM is the minute.

SS is the second.

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