SAP Knowledge Base Article - Public

2810834 - Reference Date Field Bringing Hours and Minutes as Zero in Reports

Symptom

When reporting on field "Reference Date", available under data source Installation Point, you see that it is bringing not only the date information but also the hours and minutes which makes it difficult to consume the report. It is expected that it brings only Date information, or allows to change the way it is displayed (e.g. remove/change the hours).

Environment

SAP Cloud for Customer

Reproducing the Issue

  1. Go to Business Analytics work center (or alternatively to Analysis work center).
  2. Go to Design Reports work center view (or alternatively to Reports view).
  3. Find and open the report XYZ (XYZ represents the report name).
  4. Add the field "Reference Date" into the report results.
  5. See that it brings numerous entries in the report in the format DD.MM.YYYY HH:MM:SS, which makes it difficult to consume the report.

Cause

"Reference Date" is a field of type Date/Time. Fields of such data type will always bring the information in the format DD.MM.YYYY HH:MM:SS.

Resolution

To bring only Date information, you can use the field "Registered Product Reference Date" which is also delivered in data source Installation Point, and is directly related to the field "Reference Date". It is currently not possible to change the way in which the field "Reference Date" displays the data in report results. Still, you may want to submit this as a product enhancement request through our Customer Influence portal, available in the SAP Cloud for Customer Influence.

Keywords

Reference Date; Date with zeros; Incorrect Date; Date Incorrect Format; Time Zero; Installation Point; Instalation Point; , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , LOD-CRM-SRP , Service Request Processing , How To

Product

SAP Cloud for Customer add-ins all versions