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

Returns

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

Example 1

This statement returns 2006-02-10:

RelativeDate(2006-01-31, 10)

Example 2

This statement returns 2006-01-21:

RelativeDate(2006-01-31,  - 10)

See also