SAP Knowledge Base Article - Preview

1200783 - Dates converted to text when exporting full-client reports to Excel

Symptom

When exporting full-client reports to Excel from BusinessObjects full-client and BusinessObjects in 3-tier mode (ZABO), date fields are being converted to text. This causes the text versions of dates to sort alphabetically instead of chronologically. When Excel auto filters are set, setting a filter Not Equal To will not work, nor will setting a date Between ranges.


Read more...

Product

SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3

Keywords

Date,Import,Excel , 4469115 , KBA , BI-BIP , Business intelligence platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.