613-518-1166 info@zimdatabases.com
Select Page

# \$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

\$adddays

\$addweeks

\$addyears

\$day

\$dayname

\$todate

\$weekday

+ (Add/Positive)

About Functional Expressions

Arithmetic with Dates

Was this article helpful?
###### 0 out Of 5 Stars
 5 Stars 0% 4 Stars 0% 3 Stars 0% 2 Stars 0% 1 Stars 0%
##### How can we improve this article?
Table of Contents