RelativeDate

Description

Obtains the date that occurs a specified number of days after or before another date.

Syntax

RelativeDate ( date, n )

Argument

Description

date

A value of type date

n

An integer indicating a number of days


Return value

Date. Returns the date that occurs n days after date if n is greater than 0. Returns the date that occurs n days before date if n is less than 0. If any argument's value is null, RelativeDate returns null.

Examples

This statement returns 2006-02-10:

RelativeDate(2006-01-31, 10)

This statement returns 2006-01-21:

RelativeDate(2006-01-31,  - 10)

See also

DaysAfter

RelativeDate method for DataWindows in the section called “RelativeDate” in DataWindow Reference.