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

Additional Links:

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

BIRT iHub 2