Obtains the date that occurs a specified number of days after or before another date.
RelativeDate ( date, n )
Argument |
Description |
---|---|
date |
A value of type date |
n |
An integer indicating a number of days |
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.
This statement returns 2006-02-10:
RelativeDate(2006-01-31, 10)
This statement returns 2006-01-21:
RelativeDate(2006-01-31, - 10)
RelativeDate method for DataWindows in the DataWindow Reference or the online Help