AddMonth()

<< 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