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
Adding to a Date
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
Subtracting from a Date
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