In a formula-type column, the MONTH_ADD() function displays a date obtained by adding a number of months to a date-type column.
-
Function name:
MONTH_ADD()
Syntax
MONTH_ADD(date_column, number_of_months)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date-type column to which months will be added. |
number_of_months |
The integer number of months to add. Positive to move the date forward, negative to move it backward. |
Example
MONTH_ADD($Date, 3)
The column returns the date shifted by 3 months.
Notes
- The number of months can be negative: the function then moves the date backward.
Return type
The function returns a date.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business use case
MONTH_ADD() calculates monthly deadlines: subscription end date, next billing, contract renewal date.
Best practice
Check the behavior at the end of the month (for example, January 31 + 1 month) according to the expected result for your process.