SAP Knowledge Base Article - Public

1535730 - How to convert the EPOCH Date format to dd-mm-yyyy format.

Symptom

How to convert the EPOCH Date format to dd-mm-yyyy format

Environment

  • Crystal Reports 2008
  • Crystal Reports XIR2

Cause

 EPOCH dates should be displayed in default Date format as 04/04/1975 4:44:00 PM for understanding

Resolution

  1. Create the Crystal Report using particular Database which consist of EPOCH dates

    2.   Select the EPOCH date fields in the report

    3.   To convert the EPOCH Date format to dd-mm-yyyy format use the following code :

             DateAdd("h",<EPOCH Date Field>,#01/01/1970#)

             Where <EPOCH Date Field> is the field that has the dates in EPOCH format to be converted in dd-mm-yyyy format

Keywords

EPOCH Date , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports all versions