[<<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