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