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.
Examples
This expression returns 2005-02-10:
RelativeDate(2005-01-31, 10)
This expression returns 2005-01-21:
RelativeDate(2005-01-31, -10)
See also
RelativeDate in the section called “RelativeDate” in PowerScript Reference