Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the quarter of the year in which a date or datetime expression occurs.
QUARTER(dExpression | tExpression [, nMonth])
Parameters
- dExpression
Specifies the Date expression for which you want QUARTER( ) to return a value. - tExpression
Specifies the DateTime expression for which you want QUARTER( ) to return a value. - nMonth
Specifies an optional starting month to the examined quarter. You can use this to specify quarters based on a fiscal rather than a calendar year.
Return Value
Numeric
Remarks
Returns the quarter in which a date occurs. Values can be 1, 2, 3, or 4.
See Also
CMONTH( ) | DATE( ) | DATETIME( ) | DAY( ) | MONTH( ) | YEAR( )