Difference between revisions of "IncMonth"
Jump to navigation
Jump to search
(→Usage) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
Returns a numerical value corresponding to a Julian date that is after or before the specified Julian date by a specified number of calendar months. | Returns a numerical value corresponding to a Julian date that is after or before the specified Julian date by a specified number of calendar months. | ||
| + | |||
| + | ==== Usage ==== | ||
| + | <syntaxhighlight>IncMonth(JulianDate,M)</syntaxhighlight> | ||
| − | Julian Date | + | Where: [[JulianDate]] - a numerical expression specifying the Julian Date |
| + | |||
| + | [[M]] - a numerical expression specifying the number of calendar months from the specified Julian date; if the value of [[M]] is positive, a date after the specified date will be returned; if the value of [[M]] is negative, a date before the specified date will be returned | ||
| − | |||
| − | |||
==== Example ==== | ==== Example ==== | ||
<syntaxhighlight>IncMonth(39417,1) will return a value of 39448, corresponding to January 1st, 2008, one calendar | <syntaxhighlight>IncMonth(39417,1) will return a value of 39448, corresponding to January 1st, 2008, one calendar | ||
Latest revision as of 14:01, 15 February 2023
Returns a numerical value corresponding to a Julian date that is after or before the specified Julian date by a specified number of calendar months.
Usage
IncMonth(JulianDate,M)
Where: JulianDate - a numerical expression specifying the Julian Date
M - a numerical expression specifying the number of calendar months from the specified Julian date; if the value of M is positive, a date after the specified date will be returned; if the value of M is negative, a date before the specified date will be returned
Example
IncMonth(39417,1) will return a value of 39448, corresponding to January 1st, 2008, one calendar
month after the specified date of December 1st, 2007
IncMonth(36252,-2) will return a value of 36193, corresponding to February 2nd, 1999, two calendar
months before the specified date of April 2nd, 1999
