ADD_QUARTER( )

Adds a specified number of quarters to a date value.

Syntax

ADD_QUARTER(date, n)

Arguments

date

The date or date expression that represents the start date.

n

The number of quarters to add to the start date. If you specify a negative number, the result is the number subtracted from the start date.

Returns

The date value that results from adding the specified number of quarters to the start date. A quarter is equal to three months. For example, if you add two quarters to 9/22/08, ADD_QUARTER( ) returns 3/22/09.

Example

The following example adds two quarters to each date value in the ForecastClosing field:

ADD_QUARTER([ForecastClosing], 2)

Copyright Actuate Corporation 2012