ADD_MONTH( )
Adds a specified number of months to a date value.
Syntax
ADD_MONTH(date, monthsToAdd)
Arguments
date
The date or date expression representing the start date.
monthsToAdd
The number of months 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 months to the start date. This function always returns a valid date. If necessary, the day part of the resulting date is adjusted downward to the last day of the resulting month in the resulting year. For example, if you add one month to 1/31/08, ADD_MONTH( ) returns 2/29/08, not 2/31/08 or 2/28/08, because 2008 is a leap year.
Example
The following example adds two months to each date value in the InitialRelease data field:
ADD_MONTH([InitialRelease], 2)

Additional Links:

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

BIRT iHub 2