GOMONTH( ) Function

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

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

Reference

CMONTH( ) Function

BuildDateTime Property

DATETIME( ) Function

Other Resources

Functions

Language Reference (Visual FoxPro)