List of Date Value Formatting Parameters for PowerPoint
The date formatting parameter begins with \@, followed by any combination of the following parameters. Please see the examples following this table.
|
PARAMETER |
DESCRIPTION |
|---|---|
|
Month (M) |
The letter "M" must be uppercase to distinguish
months from minutes. M Displays the month as a number without a leading 0 (zero) for single-digit months. For example, February is "2". MM Displays the month as a number with a leading 0 (zero) for single-digit months. For example, February is "02". MMM Displays the month as a three-letter abbreviation (e.g. Feb). MMMM Displays the month as its full name (e.g. February). |
|
Day (d) |
Displays the day of the month or the day of the
week. The letter "d" can be either uppercase or lowercase. d Displays the day of the week or month as a number without a leading 0 (zero) for single-digit days. For example, the sixth day of the month is displayed as "6". dd Displays the day of the week or month as a number with a leading 0 (zero) for single-digit days. For example, the sixth day of the month is displayed as "06". ddd Displays the day of the week or month as a three-letter abbreviation. For example, Tuesday is displayed as "Tue". dddd Displays the day of the week as its full name. |
|
Year (y) |
Displays the year as two or four digits. The
letter "y" can be either uppercase or lowercase. yy Displays the year as two digits with a leading 0 (zero) for years 01 through 09. For example, {{DATE \@ "yy"}} displays 1999 as “99” or 2006 as “06.” yyyy Displays the year as four digits. For example, {{DATE \@ "yyyy"}} displays 2015 as “2015.” |
|
Hours (h) |
A lowercase "h" bases time on the 12-hour clock.
An uppercase "H" bases time on the 24-hour, or military, clock. h or H Displays the hour without a leading 0 (zero) for single-digit hours. For example, {{TIME \@ "h"}} displays 9 P.M. as "9" while {{TIME \@ "H"}} displays 9 P.M. as "21". hh or HH Displays the hour with a leading 0 (zero) for single-digit hours. For example, {{TIME \@ "hh"}} displays 9 P.M. as "09" while {{TIME \@ "HH"}} displays 9 P.M. as "21". |
|
Minutes (m) |
The letter "m" must be lowercase to distinguish
minutes from months. m Displays minutes without a leading 0 (zero) for single-digit minutes. For example, {{TIME \@ "m"}} displays "2". mm Displays minutes with a leading 0 (zero) for single-digit minutes. For example, {{TIME \@ "mm"}} displays "02". |
|
A.M. and P.M. (AM/PM) |
am/pm Displays A.M. and P.M. AM/PM Displays A.M. and P.M. as uppercase. For example, {{TIME \@ h AM/PM}} and {{TIME \@ h am/pm}} display "9 AM" or "5 PM". |