In a column of type formula, the YEAR_ADD() function is the addition of a date from a column of type date and a number X either constant or from a column of type integer that represents the number of years.

Formula

YEAR_ADD(Colonne date, Nombre X)

Or

YEAR_ADD(Colonne date, Colonne année)

The first parameter is the exact name of a date column.

The second parameter is either :

• An integer that corresponds to the number of years I want to add. This number can be positive or negative.
• The exact name of a column of type integer.

Example

YEAR_ADD(Début,{Durée (années)})

Configurator

Result

The end date is the sum of the start date and the duration.