Microsoft Office Tutorials and References
In Depth Information
Symbols for some custom date formats
A complete description of
all the custom formats is
available in Access Help.
day of the month in one or two numeric digits, as needed (1 to 31)
day of the month in two numeric digits (01 to 31)
first three letters of the weekday (Sun to Sat)
full name of the weekday (Sunday to Saturday)
day of the week (1 to 7)
week of the year (1 to 53)
month of the year in one or two numeric digits, as needed (1 to 12)
month of the year in two numeric digits (01 to 12)
first three letters of the month (Jan to Dec)
full name of the month (January to December)
last two digits of the year (01 to 99)
full year (0100 to 9999)
Oren wants the dates to be displayed with a two-digit month (mm), a two-digit
day (dd), and a four-digit year (yyyy). You’ll enter this custom format now.
5. Click the Format arrow to close the list of predefined formats, and then type
mm/dd/yyyy in the Format box.
6. Press the Tab key twice to move to the Caption box, and then type Invoice Date .
See Figure 2-15.
Specifying the custom date format
Caption prop erty