How to format Date Values in Conga (PowerPoint)

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. For example, February is "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, 1999 is displayed as "99", and 2006 is displayed as "06".

yyyy Displays the year as four digits.

Hours (h)

A lowercase "h" bases time on the 12-hour clock. An uppercase "H" bases time on the 24-hour, or military, clock; for example, 5 P.M. is displayed as "17".

h or H Displays the hour without a leading 0 (zero) for single-digit hours. For example, the hour of 9 A.M. is displayed as "9".

hh or Displays the hour with a leading 0 (zero) for single-digit hours. For HH example, the hour of 9 A.M. is displayed as "09".

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, {MERGEFIELD TIME \@ "h AM/PM" } and { TIME \@ "h am/pm" } display "9 AM" or "5 PM".

EXAMPLE

OUTPUT

Master.OPPORTUNITY_CLOSEDATE(Date MM-dd-yyyy)

03-03-2008

Master.OPPORTUNITY_CLOSEDATE(Date dd/MM/yyyy)

03/03/2008

Master.OPPORTUNITY_CLOSEDATE(Date “MMM dd, yyyy”)

** Note: The formatting code is enclosed in straight quotes because it contains spaces. **

Mar 03, 2008

Master.OPPORTUNITY_CLOSEDATE(Date “MMMM d, yyyy”)

** Note: The formatting code is enclosed in straight quotes because it contains spaces. **

March 3, 2008