Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the date that is a specified number of months before or after a given Date or DateTime expression.
GOMONTH(dExpression | tExpression, nNumberOfMonths)
Return Values
Date
Parameters
- dExpression
Specifies a date expression for which GOMONTH( ) returns the date. - tExpression
Specifies a datetime expression for which GOMONTH( ) returns the date. - nNumberOfMonths
Specifies the number of months from the date or datetime. If nNumberOfMonths is positive, GOMONTH( ) returns a date that is nNumberOfMonths months after the date or datetime. If nNumberOfMonths is negative, GOMONTH( ) returns a date that is nNumberOfMonths months before the date or datetime.
Remarks
GOMONTH( ) does not support dates earlier than 1752.
Example
SET CENTURY ON
STORE GOMONTH({^1998-02-16}, 5) TO gdDeadLine
CLEAR
? gdDeadLine && Displays 07/16/1998
? GOMONTH({^1998-12-31}, 2) && Displays 02/28/1999
? GOMONTH({^1998-12-31}, -2) && Displays 10/31/1998