SAP Knowledge Base Article - Preview

2171509 - Incorrect date returned when connecting to a database using an OLE DB connection in Crystal Reports

Symptom

  • Incorrect date displayed on the report.
  • Date are off by 100 years on some report.
  • Same report were showing the expected date before.
  • Wrong date returned in Crystal Reports, when connecting to a database using an OLE DB connection, and the registry key "NumberOfYearToShift" is set to 100.


Read more...

Environment

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

Product

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

Keywords

CR, wrong date, old 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.