QUARTER (Report Builder)

Returns the calendar quarter (1-4) from a datetime.

Syntax

QUARTER(datetime)

datetime

Specifies the datetime from which the quarter (1-4) is extracted.

Example

Formula	Result
QUARTER(Start Date)	Returns the quarter value for each instance of the Start Date field, for example, 1, 2, 3, 4.
QUARTER(#10/15/2010#)	4

See Also

Concepts

Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance