DateAdd

Description

DateAdd adds a specified interval to a date.

Syntax

DateAdd(date, interval, unit)

Parameters

Parameter	Required	Type	Description
date	Yes	Date, field, or expression	Date value to adjust.
interval	Yes	Integer	Number of units to add. Use a negative value to subtract.
unit	Yes	String	Time unit, such as "day", "month", or "year".

Notes

Use this function in calculated fields, metric expressions, or query expressions where the function category is supported.

Example

DateAdd(OrderDate, 30, "day")

The expression returns the calculated result according to the current query context.