Function: addYears()

Usage

addYears(<Date>, <Number of Years>) : Date

The addYears function is used to add the specified number of years to the specified date parameter.

When you use static dates, you need to enclose the value with the # symbol. The date should be in the following format - dd/mm/yyyy hh:mm

addYears(#01/02/2021 12:00#, 2) => #01/02/2023 12:00#

Learn more about how you can get started using the Formula Field.

diffMonths()

diffDays()

diffHours()

diffMinutes()

year()

month()

monthName()

startOfMonth()

endOfYear()

dayName()

dayOfYear()

dayOfMonth()

dayOfWeek()

hour()

minute()

addYears()

endOfMonth()

addMonths()

addDays()

addHours()

addMinutes()

format()

timezone()

date()

startOfYear()

Was this article helpful?

Yes 😃 No 😞

Thanks for your feedback!