DayofWeek

Returns the number of the day in the week corresponding to the input date. The return value is an integer between 1 and 7. The value of 1 represents Sunday and the value of 7 represents Saturday.

Syntax

DayofWeek(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 6, which represents Friday.

Input is the date 2003/9/9; output is the integer 3, which represents Tuesday.