[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
FT_MADD()
Add or subtract months to/from a date
------------------------------------------------------------------------------
Syntax
FT_MADD( [ <dGivenDate> ], [ <nAddMonths> ], [ <lMakeEOM> ] )
-> dDate
Arguments
<dGivenDate> is any valid date in any date format. Defaults to
current system date if not supplied.
<nAddMonths> is the number of months to be added or subtracted.
Defaults to 0 if not supplied.
<lMakeEOM> is a logical variable indicating whether or not to
force the returned date to the last date of the month. It only
affects the returned date if <dGivenDate> is an end-of-month date.
Returns
A date.
Description
FT_MADD() adds or subtracts months to/from a given date.
If MakeEOM is passed and dGivenDate is the last day of a month,
it will return the EOM of calculated month. Otherwise it will
return the same day as the day of the passed date.
Examples
dDate := CTOD( "09/15/90" )
? FT_MADD( dDate, 1 ) // 10/15/90
? FT_MADD( dDate, -2 ) // 07/15/90
// force EOM
dDate := CTOD( "04/30/91" )
? FT_MADD( dDate, 1 ) // 05/30/91
? FT_MADD( dDate, 1, .T. ) // 05/31/91 <- forced EOM
? FT_MADD( dDate, 2 ) // 06/30/91
? FT_MADD( dDate, 2, .T. ) // 06/30/91 <- June only has 30 days
? FT_MADD( dDate, 3 ) // 07/30/91
? FT_MADD( dDate, 3, .T. ) // 07/31/91 <- forced EOM
Source: MADD.PRG
Author: Jo W. French dba Practical Computing
See Also:
FT_DAYOFYR()
FT_DAYTOBOW()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson