addYears()

The function returns a TIMESTAMP resultant of adding n years to the timestamp t.

You should use this function instead of simply adding 12 * {MONTH} or 365 * {DAY}.

Negative values for n are used in order to subtract.

Syntax

 addYears(number t, number n, timeZone time_zone) #Output: Number

Parser expression	Description
addYears(t, 10, LOCAL) timestamp t with value March 25th, 2011 23:15	The function will return a timestamp as a NUMBER with the value: March 25th, 2021 23:15

Parameter Input (data type) Description

timestamp

NUMBER

The parameter must be valid timestamp. Usually this value is retrieved from a field (e.g. due date, created date).

numberOfDays

NUMBER

The number defined here will be the offset in days.

Negative values are used to substract days.

Internally JWT multiplies this value with the time macro {DAY} to add full days to the timestamp. Learn more about time macros.

timeZone

TIMEZONE

The time zone used for the calculation.

Work days might depend on the time zone - it might be Sunday on the west coast of the US while at the same time it's already Monday in Australia.

The function returns a NUMBER.