Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
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)