Inconsistent Datatype DATE Type from Filtering
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: : 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!
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-I