Progress
Report Builder
User’s Guide


QUARTER

Calculates the number of the calendar quarter of a date expression.

SYNTAX

QUARTER ( date ) 

date

A date expression (a constant, field name, or expression whose value is a date). The following table lists the quarters into which dates fall:

Quarter
Dates
1
1/1 to 3/31
2
4/1 to 6/30
3
7/1 to 9/30
4
10/1 to 12/31

EXAMPLE

To calculate the quarter number of each date in the Start-Date field, create a calculated field containing this expression:

QUARTER(Start-Date) 

Sample data:

Start-date     QUARTER(Start-date)
12/10/92              4
04/23/93              2
09/18/93              3 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095