ADDDAYS

The ADDDAYS function allows you to add or subtract a specified number of days from a given date.

Syntax

ADDDAYS(date,value)
//adds the value to the date and returns it

Arguments

date - Date in any format. Required. This can also be a measure or a node reference.

value - Number to be added to the date. Required. Use a negative number to subtract the days from the given date.

Return Value

Date.

Example

ADDDAYS

You can also add or subtract days from a given date using the arithmetic operators.

Using Arithmetic Operators on Dates