1996681 - The formula year(currentdate) returns a wrong value in Crystal Reports

SAP Knowledge Base Article - Public

1996681 - The formula year(currentdate) returns a wrong value in Crystal Reports

Symptom

In Crystal Reports, the formula "year(currentdate)" returns a wrong year value.

Environment

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

Reproducing the Issue

  1. Open any Crystal report which is designed in previous version of Crystal Reports Designer (earlier than Crystal Reports 2008).
  2. Create a new formula "year(currentdate)".
  3. Insert the formula in the report.
  4. Refresh the report.

Resolution

  1. Launch Crystal Reports 2008/2011/2013 and open the report which contains the formula.
  2. Click on Report > Set Print Date and Time > Select the radio button: Today's Date and Time. 

Keywords

Crystal Reports, CR, year(currentdate), formula, cr , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

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