Elasticsearch filter by year from a date field

Question

i have docs with date field of the format yyyy-MM-dd. is there a way to filter only based on year part of the field.

example:

{'name': 'a', 'born': '1984-11-22'},
{'name': 'b', 'born': '1984-12-12'},
{'name': 'c', 'born': '1985-10-22'},

I want to do a term/range filter to find people born on year 1984. Any help is highly appreciated.

Answer 1

"query": {
        "filtered": {
           "filter": {
               "range": {
                  "born": {
                     "gte": "1984||/y",
                     "lte": "1984||/y",
                     "format": "yyyy"
                  }
               }
           }
        }
    }

This required rounding the input year argument as well in addition to adding the format. Without rounding by year the range query does not work as intended. Tried it on multiple date formats like dateOptionalTime, date etc.

For details on how to use Date Math see https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html

Answer 2

Yes, you can do it using a range filter and specifying a year format :

{
    "constant_score": {
        "filter": {
            "range" : {
                "born" : {
                    "gte": "1984",
                    "lte": "1984",
                    "format": "yyyy"
                }
            }
        }
    }
}