How to Group Data by Yearly QuartersID: Q95313 The information in this article applies to:
SUMMARYYou can create a report where records are grouped by yearly quarters by using a single data grouping expression. MORE INFORMATIONTo 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 |