Microsoft Office Tutorials and References
In Depth Information
Defining Fields
Figure 2-14
Symbols for some custom date formats
Symbol
Description
A complete description of
all the custom formats is
available in Access Help.
/
date separator
d
day of the month in one or two numeric digits, as needed (1 to 31)
dd
day of the month in two numeric digits (01 to 31)
ddd
first three letters of the weekday (Sun to Sat)
dddd
full name of the weekday (Sunday to Saturday)
w
day of the week (1 to 7)
ww
week of the year (1 to 53)
m
month of the year in one or two numeric digits, as needed (1 to 12)
mm
month of the year in two numeric digits (01 to 12)
mmm
first three letters of the month (Jan to Dec)
mmmm
full name of the month (January to December)
yy
last two digits of the year (01 to 99)
yyyy
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.
Figure 2-15
Specifying the custom date format
current field
custom date
format entered
Caption prop erty
entered
Search JabSto ::




Custom Search