Function reference
Obtains the date that occurs a specified number of years after or before another date.

RelativeYear ( date , n )

Argument Description
date A date value
n An integer indicating the number of years

Data type: Date
Returns the date that occurs n years after date if n is greater than 0.
Returns the date that occurs n years before date if n is less than 0.

Example 1
This expression returns 2014-02-10
RelativeYear( Date(‘2013-02-10’) , 1)

Example 2
This expression returns same date last year.
RelativeYear( Today() , -1)

Need more help with this?
Don’t hesitate to contact us here.

Thanks for your feedback.