When we import date variables, Optimize can only use the values for filtering if they match the Optimize date format specified as "yyyy-MM-dd'T'HH:mm:ss.SSSZ". It will accept and import other string formats for date variables, but any filtering for those variables will exclude results.
We should either reject variable values that don't match the correct format or attempt to normalise these values on import before we store them to Elasticsearch.
- Date variables that don't match the expected Optimize format are either rejected or normalised before storage
- We allow missing/null values to be stored
- We include the expected date variable format in our documentation and make this clearer for users