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)