Difference between revisions of "GOMONTH()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return a date that is a specified number of months before or after a particular date or datetime | Function to return a date that is a specified number of months before or after a particular date or datetime | ||
| − | |||
==Syntax== | ==Syntax== | ||
GOMONTH(<expD> | <expT>,<expN>) | GOMONTH(<expD> | <expT>,<expN>) | ||
| − | |||
==See Also== | ==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()]] | [[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== | ==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>. | 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== | ==Example== | ||
| Line 23: | Line 19: | ||
01/21/2003 | 01/21/2003 | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 12:42, 11 December 2012
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
Lianja Server, Lianja
