DayofYear

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

Syntax

DayofYear(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 1/16/2003; output is the integer 16.

Input is the date 2/17/2003; output is the integer 48.