QUARTER( ) Function

  • Article

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( )