RelativeYear ( date , n )
Section titled “RelativeYear ( date , n )”| Argument | Description |
|---|---|
| DateTime | 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
Section titled “Example 1”RelativeYear( DateTime(Date('2013-02-10'), Time('00:00:00') , 1)
This expression returns 2014-02-10 00:00:00
Example 2
Section titled “Example 2”RelativeYear( DateTime(Today(),Now()) , -1)
This expression returns same date and time as last year.