ADD_QUARTER( )
Adds a specified number of quarters to a date value.
Syntax
ADD_QUARTER(date, quartersToAdd)
Arguments
date
The date or date expression that represents the start date.
quartersToAdd
The number of quarters to add to the start date. If you specify a negative number, the result appears to subtract the number 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 data field:
ADD_QUARTER([ForecastClosing], 2)

Additional Links:

© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy

BIRT iHub 2