Skip to Content

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:

sap-pa-inconsistent-datetype.PNG

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):

sap-pa-valid-date-format-for-filtering.PNG

Hopefully this helps some people out.

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Saurabh Taneja

    would like to add that this filtering on date is only possible when connected to HANA Online mode. When connected to the HANA Offline mode then no date format works and it gives the following error-SAP PA Date Filter Error.PNGI

    (0) 

Leave a Reply