KB47572: How to display dates between a selected date and the first day of the month of the selected date in MicroStrategy

This document introduces how to display dates between a selected date and the first day of the month of the selected date. For example, if 2012-05-10 is chosen in the prompt, then the report should return data between 2012-05-01 and 2012-05-10.
Below is an example which is implemented in Strategy Tutorial project.

• Create a value prompt based on Date and Time. Name it as ChooseDate.
  

• Create a filter 'ChooseDateFilter' qualifying on ID of Day with conditions below.
   
  Attribute:Day
  
  Qualification on: ID
  
  Operator: Between
  
   
  
  Custom: MonthStartDate(?[ChooseDate])
  
  and
  
  Custom: ?[ChooseDate]
   
  

• Create a report with attribute Day and metric Profit. Add the ChooseDateFilter to report.
   

• Run report. In the Date prompt, select date 10/05/2012. See that the report returns days between 1/05/2012 and 10/05/2012.