User Tools

Site Tools


syntax:functions:addyears

AddYears(number_date, number)

Adds years to the date. Subtracts if the number is negative.

Example:

Expression Result Notes
addyears(#2019-12-12, 1) 44177 Equivalent to 2020-Dec-12
addyears(#2019-12-12, 0-1) 43446 Equivalent to 2018-Dec-12

See also:

* AddMonths(date_as_number, N)

syntax/functions/addyears.txt · Last modified: 2019/12/12 12:43 by dmitry