Week

Returns the number of the week in the year of the input date. The return value is an integer between 1 and 54.

Syntax

Week(Argument)

Where:

Argument is a metric representing a list of dates.

For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions.

Example

Input is the date 5/16/2003; output is the integer 20.

Input is the date 2003/9/9; output is the integer 37.