Week
Returns an integer (1-53) representing the week of the year in which the
given date occurs. This function is equivalent to the expression
cint(format(date, "ww"))
.
Syntax
Week(Date)
Parameters
Date
The date to return the week for.
Example
The following expression returns the number of the week in which 2007-07-05 occurred:
[DateCustom].[DateInt].[WeekInt].&[`Year("2007-07-05T12:30:10")`]&[`Week("2007-07-05T12:30:10")`]