DAYOFWEEK (Report Builder 1.0)
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 |