GOMONTH()

From Recital Documentation Wiki
Revision as of 10:29, 2 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Date and Time Data


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 Database Server, Recital Mirage Server, Recital Terminal Developer