Skip to main content
Conga Support

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.

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.

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

The letter y can be either uppercase or lowercase.

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.

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.

 
EXAMPLES

Here are several common examples of the date appearance parameter. Suppose that the field is OPPORTUNITY_CLOSEDATE and it contains the date March 1, 2014.

Date Format Examples

{{OPPORTUNITY_CLOSEDATE \@ MM-dd-yyyy}}

03-01-2014

{{OPPORTUNITY_CLOSEDATE \@ dd/MM/yyyy}}

01/03/2014

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

{{OPPORTUNITY_CLOSEDATE \@ "MMM dd, yyyy"}}

Mar 01, 2014

{{OPPORTUNITY_CLOSEDATE \@ "MMMM d, yyyy"}}

March 1, 2014

Date and Time Format Examples

{{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

  • Was this article helpful?