Difference between revisions of "GOMONTH()"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision) |
m (Text replace - "Recital" to "Lianja") |
||
Line 26: | Line 26: | ||
==Products== | ==Products== | ||
− | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
[[Category:Date and Time Data]] | [[Category:Date and Time Data]] | ||
[[Category:Date and Time Data Functions]] | [[Category:Date and Time Data Functions]] |
Revision as of 13:06, 7 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