Obtains the date that occurs a specified number of days after or before another date.
RelativeDate ( date, n )
Argument |
Description |
---|---|
date |
A date value |
n |
An integer indicating the 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.
This expression returns 2005-02-10:
RelativeDate(2005-01-31, 10)
This expression returns 2005-01-21:
RelativeDate(2005-01-31, -10)
RelativeDate in the PowerScript Reference