SAP Knowledge Base Article - Public

1394004 - DatePart function returns incorrect result in Crystal Reports.

Symptom

Week parameter in DatePart function returns incorrect/Random result.

Environment

Crystal Reports 2008.

Reproducing the Issue

  1. Create simple report.
  2. Create formula name as Test and type in as below
  3. DatePart("ww",#January 03,2009#,1,2)
  4. Test formula returns 9363 output.

Cause

This is not part of the current product functionality.

Resolution

An Enhancement Request has been raised for this issue and can be tracked with ADAPT01310469. The Enhancement Request will be reviewed in terms of future product development when considering possible new features in next major release.

Keywords

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

Product

SAP Crystal Reports XI R2