Quarter

Returns an integer (1-4) representing the quarter of the year in which the specified date occurs. This function is equivalent to the expression DatePart("q", Now()).

Syntax

Quarter(Date)

Parameters

Date
The date to return the quarter for.

Example

The following expression returns the quarter in which 2005-10-05 occurred:

[DateCustom].[DateInt].[QuarterInt].&[`Year("2005-10-05T12:30:10")`]&[`Quarter("2005-10-05T12:30:10")`]