SAP Knowledge Base Article - Preview

1969241 - Blank date displays as 1/0/1900 when exporting a report to MS Excel from Crystal Reports

Symptom

  • Blank date appears as 1/0/1900
  • When exporting to Excel, empty date displays as 1/0/1900
  • When exporting to PDF format, the blank date, exports as blank date.
  • When exporting a report that contains blank dates from Crystal Reports to MS Excel format, the blank date displays as 1/0/1900


Read more...

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

cr null empty xlsx , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.