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