SAP Knowledge Base Article - Public

1717269 - BW characteristics of data type “date time” appears as string in Crystal Reports


  • Fields of data type “Date Time” appears as text.
  • Date Time characteristic displays as string in Crystal Reports.
  • When reporting off an SAP BW BEx Query that contains characteristic of data type: "Date Time", it displays as string in Crystal Reports.


  • Crystal Reports 2008
  • SAP Crystal Reports 2011

Reproducing the Issue

  1. In BEx Query Designer, create a BEx Query containing a characteristic of data type date time.
  2. In Crystal Reports, create a new report off the BEx Query using the "SAP BW MDX Query" connection.
  3. In the "Field Explorer" , notice the data type of the characteristic that contains a date time is displayed in a string. 


  •  This is normal behavior. SAP BW BEx Query characteristics of data type: Date Time, will be displayed in a string format in Crystal Reports.


data type, date time, string, CR 2011, datatype, object, characteristic, sap, bex, bw, sap, CR2011, ADAPT01636481, 1636481 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03