Add a specified number of units to a valid date. Units can be any supported Datetime unit (e.g. minute, month, year, etc.). Input must be a column reference containing dates.

NOTE: If this function computes values out of the supported range of dates, the values are written as mismatched values, and the column is likely to be typed as a Datetime column. For more information on supported date ranges, see Datetime Data Type.


dateadd(myDate, 3, month)

Output: Returns the values in the myDate column with three months added to them. 

NOTE: Output dates are always formatted with dashes. For example, if the input values include 12/31/2016, a dateadd function output might be 03-31-2016.

 

dateadd(date,delta,date_units)


ArgumentRequired?Data TypeDescription
dateYdatetimeStarting date to compare
deltaYintegerNumber of units to apply to the date value.
date_unitsYstringString literal representing the date units to use in the comparison

date

Date values to which to add. It must be a column reference.

 

Required?Data TypeExample Value
YesString (Date column reference)LastContactDate

delta

Number of units to apply to the date values.

Required?Data TypeExample Value
YesInteger-3

date_units

Unit of date measurement to which to apply the delta value.

Required?Data TypeExample Value
YesStringyear

Accepted Value for date units:

Example - DATEADD Function

Source:

Here are some example invoices and their dates. You want to calculate the 90-day and 180-day limits, at which point interest is charged.

InvNumInvDate
inv00011/1/2016
inv00027/15/2016
inv000312/30/2016

Transformation:

Results:

NOTE: The output format is always formatted with dashes.

InvNumInvDateplus90plus180
inv00011/1/20163-31-20166-29-2016
inv00027/15/201610-13-20161-11-2017
inv000312/30/20163-30-20176-28-2017