Skip to main content

Celonis Product Documentation

ADD_DAYS
Description

ADD_DAYS adds a given number of days to a given date.

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

Output column type: DATE

If a result of type DATE is outside the interval from the year 1400 CE (including) to the year 10000 CE (excluding), it will be mapped to NULL.

Syntax
  ADD_DAYS ( table.base_column, table.days_column )
 
NULL handling

If any parameter is NULL, the result is NULL as well.

Example

[1]

Simple example for ADD_DAYS.

Query

Column1

         ADD_DAYS ( "Table1"."Base_Column" , "Table1"."Day_Column" )
        

Input

Output

Table1

Base_Column : date

Day_Column : int

Mon Jan 01 2018 00:00:00.000

1

Mon Jan 01 2018 00:00:00.000

0

Mon Jan 01 2018 00:00:00.000

-1

Result

Column1 : date

Tue Jan 02 2018 00:00:00.000

Mon Jan 01 2018 00:00:00.000

Sun Dec 31 2017 00:00:00.000

See also: