MicroStrategy ONE

QuarterStartDate

Returns the date of the first day of the quarter in which a date or timestamp occurs.

Syntax

QuarterStartDate<firstMonth>(Date/Time)

Where:

  • Date/Time is the input date or timestamp.
  • firstMonth (default value is 1) is a parameter that determines which months are considered as the first months of each quarter. You can type an integer value from 1 to 12, with 1 representing January, 2 representing February, and so on until 12 representing December. Defining one month automatically defines the first month for the other quarters as well. For example, if you specify January as the first month, April, July, and October are also considered as the first month of quarters.

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

Example

Consider a report or dashboard that includes a Day attribute with a single ID form. You can create an attribute form with the following definition:

QuarterStartDate<firstMonth=1>(Day)

For each element of the Day attribute, the new attribute form displays the start date of the quarter.