Skip to main content
Conga Support

Formatting Date Values in PDF

The following date formatting codes are used in conjunction with the “Date” parameter.

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.

Here are several common examples of the date appearance parameter. Let’s say the field we’re formatting is OPPORTUNITY_CLOSEDATE and that it contains the date 03/03/2008.

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")

The format code is enclosed in quotes because it contains spaces

Mar 03, 2008

Master.OPPORTUNITY_CLOSEDATE(Date "MMMM d, yyyy")

The format code is enclosed in quotes because it contains spaces

March 3, 2008

Todays' Date

By creating a merge field with the name Date.Today, Conga Composer will insert the current date. You may format the date using a date-formatting parameter.