# Elasticsearch multiple range query for date

**URL:** https://discuss.elastic.co/t/elasticsearch-multiple-range-query-for-date/88816
**Category:** Elasticsearch
**Created:** [June 9, 2017, 9:42am UTC](https://discuss.elastic.co/t/elasticsearch-multiple-range-query-for-date/88816 "2017-06-09T09:42:35Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![AmitP](https://avatars.discourse-cdn.com/v4/letter/a/c0e974/32.png) [@AmitP](https://discuss.elastic.co/u/AmitP)
#### Post date: [June 9, 2017, 9:42am UTC](https://discuss.elastic.co/t/elasticsearch-multiple-range-query-for-date/88816/1 "2017-06-09T09:42:35Z")

</div>

Input data ::  
{"group": {"item\_1":1,"item\_2":33205,"item\_3":0},  
"FINAL\_OUTPUT": [{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":1935,"Cprc":287.99,"type":"A","stadt":"2017-06-04","stpdt":"2017-06-10","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":1925,"Cprc":287.99,"type":"A","stadt":"2017-06-04","stpdt":"2017-06-10","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":1915,"Cprc":287.99,"type":"A","stadt":"2017-06-04","stpdt":"2017-06-10","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":490,"Cprc":479.99,"type":"B","stadt":"2007-12-20","stpdt":"9999-12-31","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":9928,"Cprc":479.99,"type":"R","stadt":"2012-08-24","stpdt":"9999-12-31","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":1945,"Cprc":287.99,"type":"A","stadt":"2017-06-04","stpdt":"2017-06-10","Xprc":0.0,"Rprc":479.99},  
{"load\_dt":"2017-06-06","item\_1":1,"item\_2":33205,"item\_3":0,"str":1905,"Cprc":287.99,"type":"A","stadt":"2017-06-04","stpdt":"2017-06-10","Xprc":0.0,"Rprc":479.99}

My Seach query ::  
GET /group\_idx/history/\_search  
{  
"query": {  
"nested" : {  
"path" : "FINAL\_OUTPUT",  
"query": {  
"bool": {  
"must": [  
{  
"range": { "FINAL\_OUTPUT.stadt": { "gte" : "2017-06-04" } }  
},  
{  
"range": { "FINAL\_OUTPUT.stpdt": { "lte" : "2017-06-10" } }  
}  
]  
}  
}  
}  
}  
}

In output i am getting wrong result ::  
{  
"load\_dt": "2017-06-06",  
"item\_1": 1,  
"item\_2": 33205,  
"item\_3": 0,  
"str": 490,  
"Cprc": 479.99,  
"type": "B",  
"stadt": "2007-12-20",  
"stpdt": "9999-12-31",  
"Xprc": 0,  
"Rprc": 479.99  
},

Please suggest how to resolve this ?

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 7, 2017, 9:43am UTC](https://discuss.elastic.co/t/elasticsearch-multiple-range-query-for-date/88816/2 "2017-07-07T09:43:01Z")

</div>

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