[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
ADDMONTH()
Adds or subtracts months to/from a date
------------------------------------------------------------------------------
Syntax
ADDMONTH([<dDate>], [<nMonth>]) --> dNewDate
Arguments
<dDate> Designates the date to which the <nMonth> months is added.
The default is the system date.
<nMonth> Designates the number of months to add to <dDate>.
Returns
ADDMONTH() returns the new date after <nMonth> is added to <dDate>.
Description
Use this function to calculate payment due dates based on an invoice
date and for similar applications. It permits you to add months to a
given date. If you use a negative number, months are subtracted.
Note
. An empty date parameter will result in an empty date.
Example
Show today's date, plus 36 months:
? "The payment period ends on: ", ADDMONTH(36)
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson