ADD_YEARS Operation

How to use the ADD_YEARS operation for Computed Attributes

Definition

The ADD_YEARS operation adds days to a date.

Example

ADD_YEARS(‘2020-03-30’, 5)

Result:
“2025-03-30”

Syntax Guide

ADD_YEARS(date, years)

date - The date to add years to

years - The number of years you want to add to the date

add-years

Compatible Attribute Types

  • Date attributes