QUARTER( )
Returns the quarter number for a specified date value.
Syntax
QUARTER(date)
Arguments
date
The date or date expression whose quarter number to get.
Returns
A number from 1 to 4 representing the quarter for a specified date value. Quarter 1 starts in January.
Example
The following example displays the quarter number for each value in the CloseDate data field:
QUARTER([CloseDate])
The following example displays a string—Q1, Q2, Q3, or Q4—for each value in the CloseDate data field:
"Q" & QUARTER([CloseDate])