MicroStrategy ONE

Custom Group Editor: Date Editor

The Date Editor allows you to qualify an attribute form or specify a default value for a value prompt. You can set either a static date or a dynamic date. The Date Editor has the following date options:

  • Static date allows you to specify a fixed date on which to qualify the attribute form, for example, a Customer Birth Date greater than 01/01/1965.

  • Dynamic date is either a fixed set of dates or a range of dates that are a fixed offset of the current date. For example, a dynamic date allows you to run a report that displays the sales for the past two months. This filter qualifies on a dynamic date of today with an offset of two months. Other examples of dynamic date qualification are:

  • Monday of this week

  • Today minus an offset of 2 months and 1 day

  • Fourth Wednesday of this month

  • Fifth of May of next year

While evaluating a dynamic date such as "first of this month minus seven days," the order in which these two parts are calculated is significant. The addition or subtraction of days, weeks, months, or years is always done first, before "first of this month," "this week," "this year," and so on is calculated. For example:

  • If today is February 13th, then "today minus seven days" is February sixth, and "the first of the month of today minus seven days" is February first.

  • However, if today is February second, then "today minus seven days" is January 26th, and "the first of the month of today minus seven days" is January first.

Accessing the Date Editor

  1. Open the Custom Group Editor. (How?)

  2. In the Attribute Qualification pane, select a date attribute, such as ship date or invoice date. Click the Date Editor icon.

Related Topics