[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
FT_ACCTMONTH()
Return accounting month data
------------------------------------------------------------------------------
Syntax
FT_ACCTMONTH( [ <dGivenDate> ], [ <nMonthNum> ] ) -> aDateInfo
Arguments
<dGivenDate> is any valid date in any date format. Defaults
to current system date if not supplied.
<nMonthNum> is a number from 1 to 12 signifying a month.
Defaults to current month if not supplied.
Returns
A three element array containing the following data:
aDateInfo[1] - The year and month as a character string "YYYYMM"
aDateInfo[2] - The beginning date of the accounting month
aDateInfo[3] - The ending date of the accounting month
Description
FT_ACCTMONTH() creates an array containing data about the
accounting month containing the given date.
An accounting period has the following characteristics:
If the first week of the period contains 4 or more 'work'
days, it is included in the period; otherwise, the first
week was included in the prior period.
If the last week of the period contains 4 or more 'work'
days it is included in the period; otherwise, the last week
is included in the next period. This results in 13 week
'quarters' and 4 or 5 week 'months'. Every 5 or 6 years, a
'quarter' will contain 14 weeks and the year will contain 53
weeks.
Examples
// get info about accounting month containing 9/15/90
aDateInfo := FT_ACCTMONTH( Ctod("09/15/90") )
? aDateInfo[1] // 199009 (9th month)
? aDateInfo[2] // 09/02/90 beginning of month 9
? aDateInfo[3] // 09/29/90 end of month 9
// get info about accounting month 5 in year containing 9/15/90
aDateInfo := FT_ACCTMONTH( Ctod("09/15/90"), 5 )
? aDateInfo[1] // 199005
? aDateInfo[2] // 04/29/89 beginning of month 5
? aDateInfo[3] // 06/02/90 end of month 5
Source: ACCTMNTH.PRG
Author: Jo W. French dba Practical Computing
See Also:
FT_DATECNFG()
FT_ACCTWEEK()
FT_ACCTQTR()
FT_ACCTYEAR()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson