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!