In a column of type formula, the function DATE_ADDNB () displays a date that is the addition of a date of a column of type date and another column of type integer. The formula counts the initial date as a full day and therefore enters the calculation formula.

For example, if my initial date is 10/10/19 and I want to add 3 days, I would have as a result : 12/10/19

Formula

DATE_ADDNB(Date column, Integer column)

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

The second parameter is the exact name of an integer-type column that corresponds to the number of days I want to add. This number can be positive or negative.

See the tips.

Example 

DATE_ADDNB (Last catchup column, +D reminder column)

Depending on the value I put in the +D Reminder column, TimeTonic automatically added as much days to the values contained in Last Catchup column.