JavaScript Editor js editor     Web development 



Main Page

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

See Also



JavaScript Editor js editor     Web development