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:
- The database must be indexed on the appropriate date field
(represented in the expressions below by <datefield>).
- 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.
- Create a group band based on this expression:
STR(YEAR( <datefield> ))+STR(INT((MONTH( <datefield> )-1)/3))
|