Format Date Values in Word

The date formatting picture switch begins with\@, followed by any combination of the following parameters.

Parameter

Description

Month (M)

Displays the month.


M	Displays the month as a number without a leading zero for single-digit months. February is shown as 2.
MM	Displays the month as a number with a leading zero for single-digit months. February is shown as 02.
MMM	Displays the month as a three-letter abbreviation. February is shown as Feb.
MMMM	Displays the full name of the month. February.

Note: The letter M must be uppercase to distinguish months from minutes.

Day (d)

Displays the day of the month or the day of the week.


d	Displays the day of the week or month as a number without a leading zero for single-digit days. The sixth day of the month is shown as 6.
dd	Displays the day of the week or month as a number with a leading zero for single-digit days. The sixth day of the month is shown as 06.
ddd	Displays the day of the week or month as a three-letter abbreviation. Tuesday is shown as Tue.
dddd	Displays the full name of the day of the week. Tuesday.

Note: The letter d can be either uppercase or lowercase.

Year (y)

Displays the year as two or four digits.


yy	Displays the year as two digits with a leading zero for years 01 through 09. 1999 is shown as 99; 2006 is displayed as 06.
yyyy	Displays the year as four digits. 1999 or 2006

Hours (h)

A lowercase h bases time on the 12-hour clock.

An uppercase H bases time on the 24-hour clock.


h	Displays the hour without a leading zero for single-digit hours. 9 A.M. is shown as 9.
H	Displays hours without a leading zero for single-digit hours on the 24-hour clock. 9AM is shown as 9. 9PM is shown as 21.
hh	Displays the hour with a leading zero for single-digit hours. 9 PM. is shown as 09.
HH	Displays the hour with a leading zero for single-digit hours on the 24-hour clock. 9 AM. is shown as 09. 9 PM is shown as 21.

Minutes (m)

Displays minutes.


m	Displays minutes without a leading zero for single-digit minutes. `{{TIME \@ "m"}}` is shown as 2.
mm	Displays minutes with a leading zero for single-digit minutes. `{{TIME \@ "mm"}}` is shown as 02.

Note: The letter m must be lowercase to distinguish minutes from months.

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. `{{NOW \@ "h AM/PM"}}` and `{{NOW \@ "h am/pm"}}` are both shown as 9 AM.

To format long text (date) in another language


Picture Switch Syntax	Result
`{{OPPORTUNITY_CLOSEDATE \@ MM-dd-yyyy}}`	03-01-2014
`{{OPPORTUNITY_CLOSEDATE \@ dd/MM/yyyy}}`	01/03/2014
`{{OPPORTUNITY_CLOSEDATE \@ "MMM dd, yyyy"}}`	Mar 01, 2014
`{{OPPORTUNITY_CLOSEDATE \@ "MMMM d, yyyy"}}`	March 1, 2014

Note: If the result contains spaces, enclose the formatting code in straight quotes.


Picture Switch Syntax	Result
`{{OPPORTUNITY_DATE_AND_TIME \@ "MM-dd-yyyy, at h:mm"}}`	08-22-2016, at 12:03
`{{OPPORTUNITY_DATE_AND_TIME \@ "MMM dd, yyyy, h:mm"}}`	Aug 22, 2016, 12:03