Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

I thought I would post this quick blog to try and help anybody out who may come across the same issue as I did.

When trying to do some data preparation via filtering on a date in the "Predict" tab of SAP Predictive Analysis, I received the following error when trying to run the analysis: "An error occurred while executing the query.Error details: SAP DBTech JDBC: [266]: inconsistent datatype: 3-3-2014 is not a DATE type const: line 1 col 779 (at pos 778)". The error with a different format is the same:

Unfortunately, this error is vague and does not point out what a valid date format is or where to find the valid date formats. I tried multiple formats until I stumbled upon one that works (ie, YYYY-MM-DD):

Hopefully this helps some people out.

If you know of documentation or other date formats that are supported, please share!

1 Comment