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