Function reference
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 |
Data type: 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.
Example 1
This expression returns 2005-02-10
RelativeDate(Date(‘2005-01-31’) , 10)
Example 2
This expression returns 2005-01-21:
RelativeDate( Date(‘2005-01-31’) , -10)
Need more help with this?
DON'T HESITATE TO CONTACT US HERE ..