GOMONTH()

From Recital Documentation Wiki
Revision as of 16:16, 2 December 2009 by Helengeorge (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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