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)
© Copyright OpenText Corp. All rights reserved. Privacy Policy | Cookie Policy