• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 3. The Table—The Heart of Any Da... > Testing and Using Custom Formats

Testing and Using Custom Formats

Suppose you have a nonstandard date or number format that you want to use. Tables 3.2 and 3.3 help you understand the symbols used to create custom date and number formats.

Table 3.2. Date Formats
Symbol Represents
/ (slash), – (dash), or . (period) Separators to delimit date values
d Day of the month in numbers with no zero added for single digit days
dd Day of the month in numbers with zero added for single digit days
ddd The first three letters of the weekday (Sun through Sat)
dddd The full name of the weekday (Sunday through Saturday)
w Day of the week (1–7)
ww Week of the year (1–53)
m Month of the year in numbers with no zero added for single digit months
mm Month of the year in numbers with zero added for single digit months
mmm The first three letters of the month (Jan through Dec)
mmmmm The full name of the month (January through December)
yy The last two digits of the year (01 through 99)
yyyy The full year (2001 through 9999)



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint