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")`]