# Get list of users - whose birthday falls in current month
**URL:** https://discuss.elastic.co/t/get-list-of-users-whose-birthday-falls-in-current-month/182133
**Category:** Elasticsearch
**Created:** [May 22, 2019, 6:06am UTC](https://discuss.elastic.co/t/get-list-of-users-whose-birthday-falls-in-current-month/182133 "2019-05-22T06:06:23Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@johnrabi](https://discuss.elastic.co/u/johnrabi)
#### Post date: [May 22, 2019, 6:06am UTC](https://discuss.elastic.co/t/get-list-of-users-whose-birthday-falls-in-current-month/182133/1 "2019-05-22T06:06:24Z")
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"
}
```
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [May 22, 2019, 7:36am UTC](https://discuss.elastic.co/t/get-list-of-users-whose-birthday-falls-in-current-month/182133/2 "2019-05-22T07:36:54Z")
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.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 19, 2019, 7:36am UTC](https://discuss.elastic.co/t/get-list-of-users-whose-birthday-falls-in-current-month/182133/3 "2019-06-19T07:36:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.