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 date value

n

An integer indicating the 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.

Examples

Example 1

This expression returns 2005-02-10:

RelativeDate(2005-01-31, 10)

Example 2

This expression returns 2005-01-21:

RelativeDate(2005-01-31, -10)

See also