WEEK (Report Builder)

Returns the numeric value for the week within the calendar year.

Syntax

WEEK(datetime)

datetime

Specifies the datetime from which the week (1-52) is extracted.

Example

Formula	Result
WEEK(Sell Start Date)	Returns the numeric value of the sales week for each instance of the Sell Start Date field, similar to the following: 25 50
WEEK(#7/22/2009#)	30

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