How to add days, weeks, months, quarters, or years to a selected date using DateAdd()

This article explains what the DateAdd() function is and provide examples of how it can be used with the binding syntax in smart templates.  

What is the DateAdd() function? 

DateAdd() is a function that calculates a date based on another date. It adds days, weeks, months, quarters, or years to the source date.

DateAdd() logic - with UnitType

DateAdd() logic - without UnitType

The syntax below can also be used. If the 'Text' variable is omitted then the Units are interpreted as days.

DateAdd() function examples

Example 1

Using DateAdd() to add 14 days/weeks/months/quarters/years based on the value of the 'Date' question originating from the response form. In this example, the value of Form.Date is "1 January 2022".

Example 2

Using DateAdd() function together with FormatDateTime() function to format the output.
In this example, the value of Date is "1 January 2022".

Example 3

When the year is a leap year, note that it makes a difference if you use a binding 'Date + 365 days' or 'Date + 1 year'.

Example 4

Using DateAdd() together with StringJoin() and FormatDateTime() functions to show a start and end date, separated by a '-,'. The binding is:

{{StringJoin(" - ", FormatDateTime(Form.Date, "d MMMM yyyy", "en-US"), FormatDateTime(DateAdd(Form.Date, 1, "M"), "d MMMM yyyy", "en-US"))}}

Example 5

Using the DateAdd() function in combination with FormatDateTime() and DateValue() to show the date + 14 days as output, when the source is a HostSystem field and the formatting is 'day-month-year hours:minutes'.