KB19323: How to create a metric that displays a date range defined by answering two date prompts in MicroStrategy Developer 9.4.x-10.x

It is possible to use a metric to display a date range defined by answering two date prompts in Strategy Developer 9.4.x-10.x. In the report, the metric should look as follows:

The following steps explain how to create a metric that displays a date range in which values come from two date prompts. The final expression depends on the database used in the warehouse.

• Create a new metric and use expression ApplySimple("convert(varchar(12),#0,101) + '-' + convert(varchar(12),#1,101)", ?, ?). Where P1 is the prompt for the initial date and P2 is the final date prompt.
  

• Click on the Validate button to recognize the prompts.
• Add this metric to a new report and add Region and Profit to the template.
• Add the filter that contains both prompts to generate the date prompt.
  

Note: The convert function is specific to SQL Server and is used for converting a Date to String.