SAP Knowledge Base Article - Preview

1217785 - IBM DB2 date fields appear with a default null value of 01/01/2001 in Crystal Reports

Symptom

  • Blank date appears as 01/01/2001.
  • Null date displays in Crystal Reports as 01/01/2001 when connecting to an IBM DB2 data source.
  • Null date in IBM DB2 are stored as 01/01/0001, but appears as 01/01/2001 in Crystal Reports when connecting to IBM DB2 via an ODBC connection. 


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, IBM, DB2, DB2 date field default value, NULL Date, Empty Date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed

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.