You can adjust a date merge field by including the ADJUST: prefix. 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.
MyDateFieldis the name of your date field (e.g. Close_Date), TODAY or NOW
Yearis the number of years you want to adjust the date
Monthis the number of months
Dayis the number of days
Houris the number of hours
Minuteis the number of minutes
Secondis the number of seconds
Notes
You 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 either a positive or negative integer: future dates are positive integers, past dates negative (e.g. 6 or -6).
You may also use a picture switch to edit how the date field will appear, e.g. {{ADJUST:Close_Date:0:0:30:0:0:0 \@ "MMMM d, yyyy"}}. However, picture switches only work 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