DAYOFWEEK (Report Builder)

Returns the day of the week, starting with Monday. Monday = 1 through Sunday = 7.

Syntax

DAYOFWEEK(datetime)

datetime

Specifies the datetime from which the day of the week is extracted.

Example

Formula	Result
DAYOFWEEK(#4/3/2009#)	5
DAYOFWEEK(Sell Start Date)	Returns a day of the week for each instance of the Sell Start Date field similar to the following: 1 2 7

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