Skip to main content

Date.AddYears

Adds the specified years to the date.

Syntax​

Date.AddYears(
    dateTime as any,
    numberOfYears as number
) as any

Remarks​

Returns the date, datetime, or datetimezone result of adding numberOfYears to a datetime value dateTime.

  • dateTime: The date, datetime, or datetimezone value to which years are added.
  • numberOfYears: The number of years to add.

Examples​

Example #1​

Add 4 years to the <code>date</code>, <code>datetime</code>, or <code>datetimezone</code> value representing the date 5/14/2011.

Date.AddYears(#date(2011, 5, 14), 4)

Result:

#date(2015, 5, 14)

Example #2​

Add 10 years to the <code>date</code>, <code>datetime</code>, or <code>datetimezone</code> value representing the date and time of 5/14/2011 08:15:22 AM.

Date.AddYears(#datetime(2011, 5, 14, 8, 15, 22), 10)

Result:

#datetime(2021, 5, 14, 8, 15, 22)

Category​

Date