Difference between revisions of "GOMONTH()"

Revision as of 05:23, 25 October 2011

Purpose

Function to return a date that is a specified number of months before or after a particular date or datetime

Syntax

GOMONTH(<expD> | <expT>,<expN>)

See Also

CDOW(), CMONTH(), CTOD(), DATE(), DATETIME(), DAY(), DAYS(), DMY(), DOW(), DTOC(), DTOM(), DTOS(), DTOV(), EPOCH(), MDY(), MONTH(), MTOD(), QUARTER(), SET CENTURY, SET DATE, SET EPOCH, SET HOURS, SET MARK, STOD(), VTOD(), WEEK(), YEAR()

Description

The GOMONTH() function returns a date which is <expN> months before or after the date expression <expD> or datetime expression <expT>. If <expN> is a negative number, the GOMONTH() function returns a date that is before <expD> or <expT>. If <expN> is a positive number, the GOMONTH() function returns a date that is after <expD> or <expT>.

Example

?gomonth({04/14/2004}, 4)
08/14/2004
 
? gomonth({01/21/2004 03:18:33 PM},-12)
01/21/2003

Products

Recital Server, Recital