Skip to main content
Conga Support

List of Date Values Formatting Parameter 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.

yyDisplays 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.”

yyyyDisplays 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 HDisplays 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 HHDisplays 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.

mDisplays minutes without a leading 0 (zero) for single-digit minutes.  For example, {{TIME \@ "m"}} displays "2".

mmDisplays minutes with a leading 0 (zero) for single-digit minutes. For example, {{TIME \@ "mm"}} displays "02".

A.M. and P.M. (AM/PM)

am/pmDisplays A.M. and P.M.

AM/PMDisplays A.M. and P.M. as uppercase. For example, {{TIME \@ "h AM/PM"}} and {{TIME \@ "h am/pm"}} display "9 AM" or "5 PM".

 
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