Applies to: CELONIS 4.0 CELONIS 4.2 CELONIS 4.3 CELONIS 4.4 CELONIS 4.5 CELONIS 4.6

Description

ADD_YEARS adds a given number of years to a given date.

Supported input column types: base_column -> DATE, years_column -> INT

Output column type: DATE

Syntax

ADD_YEARS ( table.base_column, table.years_column )

NULL-values: If any parameter is NULL, the result is NULL

[1] Simple example for ADD_YEARS.

Query

ADD_YEARS ( "Table1"."Base_Column", "Table1"."Year_Column" )

Input

Output