How to Group Data by Yearly Quarters

ID: Q95313

The information in this article applies to:

Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a
Microsoft FoxPro for Windows, versions 2.5 and 2.5a

SUMMARY

You can create a report where records are grouped by yearly quarters by using a single data grouping expression.

MORE INFORMATION

To create such a group:

1. The database must be indexed on the appropriate date field

   (represented in the expressions below by <datefield>).

2. Each quarter can be numbered with the expression:

      INT((MONTH(<datefield>)-1)/3) + 1

   Quarter numbers change every three months. Subtracting 1 from the
   month number makes the first month of each quarter a new multiple
   of 3: Jan.= 0, Apr.= 3, Jul.= 6, Oct.= 9.

   The month numbers are then divided by 3 and the returned integer
   value is 0 for the first three months, 1 for the next three months,
   and so on. The correct quarter number is then found by adding 1 to
   the integer value.

3. Create a group band based on this expression:

      STR(YEAR( <datefield> ))+STR(INT((MONTH( <datefield> )-1)/3))

Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a KBCategory: kbprg KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995