1976422 - Error: ‘HY000:MALFORMED_QUERY' when refreshing a report based off Salesforce.com, that filter data on a date, in Crystal Reports

• When refreshing a report in Crystal Reports 2013, it fails with the error: "Failed to retrieve data from the database".
   
• Used to be able to refresh the same report in Crystal Reports 2011.
     

• When reporting off Salesforce.com in Crystal Reports 2013, if the report contains a Record Selection Formula that filter on date fields, it fails with the following errors:
    
  "SAP Crystal Reports: Failed to retrieve data from the database"

  "SAP Crystal Reports: Database Connector Error: ‘HY000:MALFORMED_QUERY: CreatedDate >= YYYY-MM-DD 00:00:00 ) AND ( CreatedDate < YYYY-MM-DD Error at Row:1:Column:81  line 1:81 no viable alternative at character ‘ [Database Vendor Code: 70]’ "
       

• Note: Images and data in this SAP Knowledge Base Article is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.  

• SAP Crystal Reports 2013
     
• Salesforce.com

CR, Salesforce, SForce, SP02, SP03, SP04, Salesforce.com, ADAPT01718495,  ADAPT01718496, ADAPT01719327, ADAPT01719328, date field, filter data on a date, filter by date, failed to retrieve data from the database, HY000, MALFORMED_QUERY, CreatedDate , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Bug Filed