Changes
IncMonth
,Created page with "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. Julian Date indicates th..."
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.
Julian Date indicates the number of days that have elapsed since January 1st, 1900.
==== Usage ====
<syntaxhighlight>IncMonth(JulianDate,M)</syntaxhighlight>
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 ====
<syntaxhighlight>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</syntaxhighlight>
[[Category:Date and Time Routines]]
Julian Date indicates the number of days that have elapsed since January 1st, 1900.
==== Usage ====
<syntaxhighlight>IncMonth(JulianDate,M)</syntaxhighlight>
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 ====
<syntaxhighlight>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</syntaxhighlight>
[[Category:Date and Time Routines]]