# Find age range according to Birthdate
**URL:** https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691
**Category:** Elasticsearch
**Created:** [April 20, 2019, 8:05am UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691 "2019-04-20T08:05:05Z")
**Posts on this page:** 16
**Page:** 1
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 20, 2019, 8:05am UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/1 "2019-04-20T08:05:05Z")
My date of birth is storing as this "1995-08-10 00:00:00.314"
ANd now I want to write a search query so that it can return the data according to the age of the person. My condition is I want to return data within 21-31 age, I tried below query but it didn't work
POST /datewise/testEnvo/\_search
{
"query": {
"range": {
"user.dateOfBirth": {
"gte": "2016-01-01 00:00:00",
"lte": "2026-01-01 00:00:00"
}
}
}
}
I'm a little confused in here please help me out.
Thanks
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 3:25pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/2 "2019-04-22T15:25:46Z")
In your case I think what it would work is something like:
```auto
GET discuss/_search
{
"query": {
"range": {
"user.dateOfBirth": {
"gte": "now-31y/d",
"lte": "now-21y/d"
}
}
}
}
```
Note that the user birthdate needs to be lower than 21 years from now and bigger 31 years from now.
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 5:13pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/3 "2019-04-22T17:13:15Z")
Hi @Ignacio_Vera thanks for your reply , but that didn't work
I have attached an image can you look at the "user.dateOfBirth" i want to bring the result if my age is in between 21-30
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 5:29pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/4 "2019-04-22T17:29:19Z")
I need more information about what you are doing. Can you give an example of what is failing for you?
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 5:40pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/5 "2019-04-22T17:40:42Z")
I will have multiple data just like in the image I attached. Those data will have "user.dateOfBirth" field in each data. Now I want to find the age according to that "user.dateOfBirth" field and return all the result which are in between age 21-30. I know it would be a lot easier if I had a number instead of that date in "user.dateOfBirth" field.
I tried your approach but it didn't work, and I also tried times range query but that also didn't work maybe there's a condition that I need to apply to query, but I don't know what is it.
POST /datewise/testEnvo/\_search
{
"query": {
"range": {
"user.dateOfBirth": {
"gt": "now-21y/d",
"lt": "now-30y/d"
}
}
}
}
If you can guide me through this that would be a big help 🙂
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 5:47pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/6 "2019-04-22T17:47:50Z")
Having a number would not be very useful as it changes over time 🙂
The query I sent to you works for me so I need more information why it does not work for you. If you can reproduce what it is not working for you, it would be very helpful. In the example you showed before the query only hits the record with date of birth in 1995 but of course it won't match the record in 2019.
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 5:52pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/7 "2019-04-22T17:52:58Z")
Here I used your query it didn't return any data though ☹
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 5:54pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/8 "2019-04-22T17:54:40Z")
Can you sent the mapping you are using? Probably that give us the answer
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [April 22, 2019, 5:59pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/9 "2019-04-22T17:59:12Z")
It looks like you have swapped the range limits. Copy and paste the example Ignacio provided above and show us what the result is.
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 6:04pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/10 "2019-04-22T18:04:27Z")
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 6:13pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/11 "2019-04-22T18:13:42Z")
which mapping , You mean how I am storing my data ?
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 6:16pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/12 "2019-04-22T18:16:23Z")
Yes, basically is the output of the mapping API:
[https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-mapping.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/indices-get-mapping.html)
This is the schema that Elasticsearch is using to index the data.
so in your case it should execute the following command in kibana:
```auto
GET /datewise/_mapping
```
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 6:20pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/13 "2019-04-22T18:20:30Z")
Here
---
### Author:  [@Ignacio\_Vera](https://discuss.elastic.co/u/Ignacio_Vera)
#### Post date: [April 22, 2019, 6:39pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/14 "2019-04-22T18:39:50Z")
You are using dynamic mapping and the data is being indexed as `text` instead of `date`. That is the reason you get nothing back from your query.
You need to declare explicitly the mapping of your data as shown here:
[https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#\_example\_mapping](https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping.html#_example_mapping)
---
### Author:  [@chan\_1di](https://discuss.elastic.co/u/chan_1di)
#### Post date: [April 22, 2019, 10:35pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/15 "2019-04-22T22:35:38Z")
Hi @Ignacio_Vera thanks for your quick response , everything works perfectly now 😃
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 20, 2019, 10:35pm UTC](https://discuss.elastic.co/t/find-age-range-according-to-birthdate/177691/16 "2019-05-20T22:35:46Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.