Returns the date that is a specified number of months before or after a given Date or Date/Time expression.
GOMONTH(dExpression | tExpression, nNumberOfMonths) |
Parameters
- dExpression
- Specifies a date expression for which GOMONTH(В ) returns the date.
- tExpression
- Specifies a date/time expression for which GOMONTH(В ) returns the date.
- nNumberOfMonths
- Specifies the number of months from the date or date/time. If nNumberOfMonths is positive, GOMONTH(В ) returns a date that is nNumberOfMonths months after the date or date/time. If nNumberOfMonths is negative, GOMONTH(В ) returns a date that is nNumberOfMonths months before the date or date/time. For example, -1 means -31 days.
Return Value
Date
Remarks
GOMONTH(В ) does not support dates earlier than 1753.
Example
В | Copy Code |
---|---|
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 |