Description
Obtains the date that occurs a specified number of days after or before another date.
Syntax
RelativeDate ( date, n )
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
RelativeDate method for DataWindows in the section called “RelativeDate” in DataWindow Reference.
