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)

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment