<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