How to build date_range agg when date field has default format but the value is stored as seconds?

Elastic Stack Elasticsearch
1

Hi,

ES v5.3.

I've a date field "created" with default format strict_date_optional_time||epoch_millis. But the values are stored in seconds. I need to build date_range aggregation query but I don't get any result. I've tried, yyyy-MM-dd, seconds and milliseconds but no luck. I am sure this happening because of the wrong value store in the date field. It should have been either millisec or yyyy-MM-dd. Is it possible to get the query working without reindexing field with milliseconds?

Thanks

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.