Get list of users - whose birthday falls in current month

Elastic Stack Elasticsearch
1

Hi Team ,
i am having some 10 documents in my index,like below i mentioned , how to write the query to Get list of users - whose birthday falls in current month ? can anyone help me to resolve this isssue?

                       {
                       "fName" : "william",
                       "pinCode" : 123456,
                      "birthDate" : "02-MAR-2019"
                        },
                        {
                        "fName" : "smith",
                        "pinCode" : 456,
                         "birthDate" : "23-MAR-2019"
                         }
2

I'd recommend to compute that at index time and add a field month in your document.
You can do it I guess with a painless processor in an ingest pipeline.

3

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