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")`]