Date to Quarter Function

[Paulr81755]

Does anyone know of or have a function that converts a date to a calendar quarter, e.g., 1/1/2004 to "First Quarter"? Thank you.

[transpower]

Use

Case (

WeekOfYear(date) <= 13 ; "First Quarter" ;

WeekOfYear(date) <= 26 ; "Second Quarter" ;

WeekOfYear(date) <= 39 ; "Third Quarter" ;

"Fourth Quarter"

)

[-Queue-]

If quarter is determined by first of the month, try

MiddleWords( "First Second Third Fourth"; (Month(date) + 2) / 3; 1 ) & " Quarter"