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

KB249024: Date attributes are formatted as text instead of date data type using MicroStrategy Office


Community Admin

• Strategy


This Knowledge Base article describes an issue where executing a report containing a date formatted attribute through MicroStrategy Office imports the dates as text, i.e ="dd.MM.yyyy" instead of dates. The article provides steps how to resolve this issue.

SUMMARY
When executing a report containing a date formatted attribute, the dates are imported into the spread sheet as text, i.e ="dd.MM.yyyy" instead of dates.
Applying steps outlined in KB41220 - How MicroStrategy Office 9.2.x and 9.3.0 handle formatting of attributes with a format type of Date do not resolve the issue.

ka04W00000148OPQAY_0EM4400000025bJ.jpeg

 
CAUSE
This issue might occur when setting a specific Excel format language in the Strategy Office properties.
 
ACTION
Change the Excel format language to "Set language automatically".

ka04W00000148OPQAY_0EM4400000025bE.jpeg

 
After restarting Microsoft Excel, the date elements are formatted with the date data type.

ka04W00000148OPQAY_0EM4400000025bG.jpeg

 
 
 
 


Comment

0 comments

Details

Knowledge Article

Published:

June 13, 2017

Last Updated:

June 13, 2017