1933822 - Default Date changed from 01/01/1900 to 02/07/2036

SAP Knowledge Base Article - Public

1933822 - Default Date changed from 01/01/1900 to 02/07/2036

Symptom

  • List of Values prompts with incorrect Date value. 
  • Database Date value changed from 01/01/1900 to 02/07/2036 in LOV of Crystal Report connected to .unv Universe.

Environment

  • Crystal Reports 2011 SP08
  • Crystal Reports 2013 SP01
  • Oracle Database 11g
  • Universe Designer
  • BI 4.0

Reproducing the Issue

  1. Create Crystal report of a .unv universe with Oracle date field that has a value 01/01/1900.
  2. In Query Panel add a filter based on the date field and select "prompt".
  3. Refresh the report and observe incorrect value in LOV prompt.

Cause

In 32 bit representation of NTP TimeStamp used by Oracle 1/1/1900 and 2/7/2036 are zero values, because  

2/7/2036  - 1/1/1900 = 136 years 33 days = 4,294,967,296 seconds

Converting seconds from Decimal to Binary gets 32 bits overflow

(4294967296)10 = (100000000000000000000000000000000)2

Crystal Reports incorrectly converts 32 bit zero value to the incorrect Date value.

Resolution

Update Crystal Reports as this is not an issue in Crystal Reports 2013 SP02.

Workaround: Enter Date value manually.

See Also

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports 2011