ADDDATE
The following section describes the syntax and usage of the ADDDATE function in ActivityInfo.
Description
The ADDDATE function is used to add a given number of days onto a Date. It can also be used to subtract from a date by giving a negative number of days.
Syntax
ADDDATE(date,numDays)
Argument | Required | Description |
---|---|---|
date | Yes | The Date to add/subtract from. The value must be a Date. |
numDays | Yes | The number of days to add/subtract from the Date. The value must be numeric. |
Result
A Date value the specified number of days before or after the given Date.
Example
We will be using the ADDDATE function to calculate a Date value 30 days after a given date.
Arguments
We will be using the Date field "Dates" (with code "dates"), and adding constant of 30 days.

Formula
ADDDATE(dates, 30)
Results

We will be using the ADDDATE function to calculate a Date value 30 days before a given date.
Arguments
We will be using the Date field "Dates" (with code "dates"), and adding constant of -30 days.

Formula
ADDDATE(dates, -30)
Results
