Conga Product Documentation

Welcome to the new doc site. Some of your old bookmarks will no longer work. Please use the search bar to find your desired topic.

download

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.

Formatting Codes:

  • 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 is shown as 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.

Formatting Codes:

  • 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 is shown as Tuesday.
Note: The letter d can be either uppercase or lowercase.

Year (y)

Displays the year as two or four digits.

Formatting Codes:

  • 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.
    • Years are shown in full, such as 1999 or 2006
Note: 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.

Formatting Codes:

  • 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.
    • 9 AM is shown as 9. 9 PM 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.

Formatting Code

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

Formatting Codes:

  • 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.