KB44021: Get incorrect value of date distance in derived metric in MicroStrategy Developer 9.x

SYMPTOM:
 
In Developer, a derived metric is defined as (EndDate - StartDate) to compute the date distance between the two days. However, it get incorrect result which is one day less than the actual date difference as shown blow.
 

 
 
 
REPRODUCE STEPS:
 
 
 
Max(){~+}
 
Max(){~+}
 
 

1. In Developer, create a report with attribute Start Date and End Date who are in date format.
2. Create two derived metrics StartDate and EndDate based from the date attributes. Define the expression as below:
3. Define a third derived metric Date Diff as below:
    
   (EndDate - StartDate)
    
   
4. Run report. Notice that the value of Date Diff is one day less than the actual date distance. Take the first row as example, the differnce between 06/01/2009 and 01/01/2009 should be 5 rather than 4.
    
    
   

CAUSE:
 
This is a known issue in Strategy Developer 9.x.
 
ACTION:
 
Strategy will continue to investigate and post updates as soon as they are available.
 
WORKAROUND:
 
Users can run the same report in Strategy Web. In Web, the date distance can be correctly computed.