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.
Comments
0 comments
Please sign in to leave a comment.