This article describes how to adjust date merge fields in Conga Composer Word Templates. You can adjust a date merge field by including the ADJUST: prefix. For example, you could display the date 30 days past an Opportunity Close Date.

The ADJUST: prefix works with any Salesforce date field or the Conga TODAY or NOW fields from the System dataset, which is provided by default in the Template Builder.

Table 1. ADJUST

Syntax{{ADJUST:MyDateField:Year:Month:Day:Hour:Minute:Second}}
Values
  • MyDateField is TODAY, NOW, or the name of your date field; for example, Close_Date.
  • Year is the number of years you want to adjust the date.
  • Month is the number of months you want to adjust the date.
  • Day is the number of days you want to adjust the date.
  • Hour is the number of hours you want to adjust the date.
  • Minute is the number of minutes you want to adjust the date.
  • Second is the number of seconds you want to adjust the date.
NotesYou must use all of the data elements (years, months, days, hours, minutes, seconds). For any element that you do not want to adjust, insert a zero (0).

Dates can be adjusted for the future or past with a positive or negative integer, respectively.

You can also use an appearance parameter to edit how the date field will appear. However, appearance parameters work only with Master fields.

Examples
  • {{ADJUST:Close_Date:0:0:30:0:0:0}} - The value of the Close_Date field is adjusted to 30 days in the future.
  • {{ADJUST:Created_Date:0:-6:0:0:0:0}} - The value of the Created_Date field is adjusted to 6 months ago.
  • {{ADJUST:Close_Date:0:0:30:0:0:0 \@ "MMMM d, yyyy"}} - The value of the Close_Date field is adjusted to 30 days in the future, and an appearance parameter formats the result.