<< Click to Display Table of Contents >> Navigation: Available Functions > AddMonth() |
Syntax
AddMonth( <DateValue>, <NumericValue> )
Purpose
Adds or subtracts months to/from a date.
Parameters
<DateValue> is usually a date field, such as donation date.
<NumericValue> is the number of months to advance the specified date <DateValue> by. <NumericValue> is usually a specific value you would enter, such as 1, 2, 3, etc.
Returns
AddMonth() will return a date which is <NumericValue> months past the specified <DateValue> date.
Usage
AddMonth() can be used to age a date by any number of months. You could use it to calculate payment due dates based on an invoice date when creating a billing report for pledges. AddMonth() essentially permits you to add months to a given date. If you use a negative number, months are subtracted.
Example
The following examples illustrate AddMonth():
CALL |
RESULT |
---|---|
DATE() |
02/25/2014 |
AddMonth( DATE(), 5 ) |
07/25/2014 |
AddMonth( DATE(), 12 ) |
02/25/2015 |