Date information from the source is represented as a text string, with the format YYYYMMDD. We need the information to be represented as a date-time data type in Sisense.
This will utilize a custom field to convert the value. The original date value needs to be defined in the ElastiCube as a text data type. The following code gets the correct results:
The attached .ecdata file provides data that demonstrates this functionality.