How Can We Help?
$addmonths
Calculates a date value by adding months to (or subtracting months from) a specified date value.
Syntax
$addmonths(date,number)
where
| date | a date, or an expression that evaluates to a DATE data type |
| number | a number, or an expression that evaluates to a number |
Return Value
Number, representing a DATE value.
Comments
Use $addmonths to perform arithmetic with date values. The $addmonths function calculates a date value by adding a number representing months to a date value. If number is negative, the effect is to subtract the months from the date.
The + (add) and – (subtract) operators can be used to achieve the same results.
If date or the result of the $addmonths expression is an invalid date (e.g., 19930231), it is adjusted to produce a valid date (e.g., 19930228).
Example
If $Date has the value 19981225, then:
$addmonths($date,3)
Evaluates to 19990325.
$addmonths($date,-3)
Evaluates to 19980925.
$addmonths($date,20)
Evaluates to 20000825.
$addmonths(19980131,1)
Evaluates to 19980228 (note truncation).
See Also
English 
Portuguese