KB36445: Dates in a Report Services document are formatted as mm/dd/yyyy when executed from MicroStrategy Developer or Web 9.x in a locale where the expected format would be dd/mm/yyyy

SYMPTOM:
On executing a Report Services document, a user may note that the date given in the output is displayed as mm/dd/yyyy, whereas the expected format would be dd/mm/yyy, on the basis of the language selection at project and user-level, in addition to the standard conventions for the locale. This persists after modifying the date format in the underlying report.
 
STEPS TO REPRODUCE:
This issue can be reproduced in the Tutorial project by taking the following steps:

• Set all language options in Strategy Desktop and Web, both at project and user level, to a language, such as Polish, for which the expected date format would be dd/mm/yyyy:
  Project level data preference:
  

•  
  User language preferences:
  

• Ensure that the regional settings on the client machine are also modified to match the language choice made in step 1: 
   
  

• Execute the 'Sales Review' document and note that the dates appear in the form of mm/dd/yyyy in the Sales Review Graph under the 'Daily Revenue' tab:
  

 CAUSE:
The format of the attribute 'Day' in the base report, from which data for the above graph is drawn, was set to display as mm/dd/yyyy.  The report was then added with formatting as a dataset for the report.  As a result, any modification made to the format of relevant attribute in the report will not be reflected in the document.
 
ACTION:
Modifying the dataset report, such that the 'Day' attribute uses the formatting as desired, and adding this back to the document in question will lead to the date being displayed as desired: