​The following date and time formatting codes are used in conjunction with date and/or time merge fields.
 
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.
              For example, February
is "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.
For example, 1999 or 2006.
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 HH     Displays the hour with a leading 0 (zero) for single-digit hours.
                   For 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".
Seconds (s) A lowercase “s” represents seconds for time formatting. 
 
s           Displays seconds without a leading 0 (zero) for single-digit seconds.
             For example, { TIME \@ “s” } displays “2”.
 
ss         Displays seconds with a leading 0 (zero) for single-digit seconds.
             For example, { TIME \@ “ss” } displays “02”.
 
A.M. and P.M. (am/pm) am/pm  Displays AM and PM
             For example, {MERGEFIELD NOW \@ "h am/pm" } displays "9 AM".



Examples:

Here are several common examples of the date appearance parameter. Let’s say the fields we’re formatting are OPPORTUNITY_CLOSEDATE which contains the date March 3, 2008 and ACCOUNT_LASTMODIFIEDDATE containing the date and time February 16, 2008 at 9:28.06 a.m.

 
EXAMPLE OUTPUT
{ MERGEFIELD OPPORTUNITY_CLOSEDATE \@ MM-dd-yyyy } 03-03-2008
{ MERGEFIELD OPPORTUNITY_CLOSEDATE \@ dd/MM/yyyy } 03/03/2008
{ MERGEFIELD OPPORTUNITY_CLOSEDATE \@ "MMM dd, yyyy" }
 
            Note: The formatting code is enclosed in straight quotes because it contains spaces.
Mar 03, 2008
{ MERGEFIELD OPPORTUNITY_CLOSEDATE \@ "MMMM d, yyyy" }
 
            Note: The formatting code is enclosed in straight quotes because it contains spaces.
March 3, 2008
{ MERGEFIELD ACCOUNT_LASTMODIFIEDDATE \@ "h:mm am/pm" } 9:28 AM
{ MERGEFIELD ACCOUNT_LASTMODIFIEDDATE \@ "hh:mm.ss" } 09:28.06
{ MERGEFIELD ACCOUNT_LASTMODIFIEDDATE \@ "hh:mm.ss am/pm" } 09:28.06 AM


Helpful tips to format date or time fields in Word templates:

Add a “picture switch” to the field. To do this: Right-click and choose “Toggle Field Codes”

Remove “\* MERGEFORMAT”, if it appears

Include a picture switch similar to \@ MM/dd/yyyy or \@ dd-MMM-yyyy

​Tip for HTML Email Templates:
​
Format a date field in Conga Email Templates in HTML for the am/pm switch:

{Date \@ "h:mmtt"}​