MicroStrategy ONE

Date and Time Editor

The Date and Time Editor allows you to qualify an attribute form or specify a default value for a value prompt. You can define a static date, a dynamic date, a static time, or a dynamic time. The Date and Time Editor contains the following tabs:

For directions to access the Date and Time Editor, see Accessing the Date and Time Editor below.

Date tab

The Date tab of the Date and Time Editor is available for any attribute form that has a Date or Datetime format type. The Date tab contains the following 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:

  • Today minus an offset of 2 months

  • Today minus an offset of 2 months and 1 day

  • Monday of this week

  • Monday of last week

  • The second of this month

  • The second of last month

  • The second of the current month, for last year (for example, if the current month is January, then the second day of January of last year)

  • The fourth Monday of this month

  • The fourth Monday of next month

  • The fourth Monday of the current month, for last year

  • Four days from the last day of this month

  • Four days from the last day of next month

  • Four days from the last day of the current month, for last 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.

Time tab

The Time tab of the Date and Time Editor is available for any attribute form with a Datetime format type. The Time tab contains the following options:

  • Static hour allows you to specify a fixed hour on which to qualify the attribute form, for example, later than 1 PM.

  • Dynamic hour allows you to define a dynamic hour on which to qualify the attribute form, for example, the current time minus 1 hour or plus 4 hours.

  • Static minute allows you to specify a fixed minute on which to qualify the attribute form, for example, later than 30 minutes past the hour.

  • Dynamic minute allows you to specify a dynamic minute on which to qualify the attribute form, for example, the current minute minus 1 minute or plus 30 minutes.

Dynamic times work in the same manner as dynamic dates. Hours, minutes, or both can be calculated dynamically. Hours, minutes, or both can be defined as static. For example, if the current time is 12:40 PM:

  • Then "this hour plus 1 hour" and "this minute minus 0 minutes" (dynamic hour and dynamic minute) is calculated as 1:40 PM.

  • Then "this hour plus 1 hour" and "Static Minute = 24" (dynamic hour and static minute) is calculated as 1:24 PM.

  • Then "Static Hour = 11 AM" and "this minute minus 10" (static hour and dynamic minute) is calculated as 11:30 AM.

  • Then "Static Hour = 11 AM" and "Static Minute = 24" (static hour and static minute) is calculated as 11:24 AM.

Accessing the Date and Time Editor

From the Filter Editor

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

From the Prompt Generation Wizard

On the Default Value Selection page, click the Date Editor icon.

Related Topics