EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB46259: The dd-MMM-yy date format is not applied correctly when using Number and Date Format as Portuguese (Brazil) in MicroStrategy Web 9.x


Community Admin

• Strategy


The dd-MMM-yy date format is not applied correctly when using Number and Date Format as Portuguese (Brazil) in MicroStrategy Web 9.x

SYMPTOM:
 
When setting the option Number and Date Format as Portuguese (Brazil) in Strategy Web preferences, the dd-MMM-yy date format is applied differently from previous versions. In previous version, the behavior is display the months as Jan, Feb and Mar. In new version, it display as jan, fev and mar.
 
STEPS TO REPRODUCE:
 
In the Strategy Tutorial Project:
1 - Create a report with Day, Month and Year (attributes) and Revenue (metric) 
2 - Move Year and Month to Page by
3 - Run the report and format the Day values as dd-MMM-yy
4 - The result should be like 01-Jan-10
 

ka04W000000Ogd3QAC_0EM4400000026Hs.png


5 - In Preferences > Project Default > Language > Number and Date Format > select Portuguese (Brazil)
 

ka04W000000Ogd3QAC_0EM4400000026Hd.png


6 - Apply and return to Grid
7 - The grid will display the date as 01-jan-10 instead of 01-Jan-10
 

ka04W000000Ogd3QAC_0EM4400000026He.png

 
CAUSE:
 
This is working as design. Microsoft made the decision that return lower case for Month format for Brazil. 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017