# Help required
**URL:** https://discuss.elastic.co/t/help-required/94059
**Category:** Elasticsearch
**Created:** [July 21, 2017, 6:02am UTC](https://discuss.elastic.co/t/help-required/94059 "2017-07-21T06:02:24Z")
**Posts on this page:** 19
**Page:** 1
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 6:02am UTC](https://discuss.elastic.co/t/help-required/94059/1 "2017-07-21T06:02:24Z")
Hi everyone, I am trying to search a keyword in date range. Can anyone help me out?
curl -XGET '[http://localhost:9200/201706/\_search](http://localhost:9200/201706/_search)' -d '{ "query" :{ "bool" : { "must" : [{ "match" : { "message": "isis"} }, { "range" :{ "created\_at" :{ "gte" :"2017-06-01", "lte" : "2017-06-30", "format" :"yyyy/mm/dd||yyyy"}}}]}}}'
Thanks, Akhil
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 6:14am UTC](https://discuss.elastic.co/t/help-required/94059/2 "2017-07-21T06:14:09Z")
It looks like your date pattern does not match the data: `2017-06-01` vs `yyyy/mm/dd`. Based on the [example in the documentation](https://www.elastic.co/guide/en/elasticsearch/reference/5.5/query-dsl-range-query.html#_date_format_in_range_queries) it also looks like your pattern should be `yyyy-MM-dd`.
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:18am UTC](https://discuss.elastic.co/t/help-required/94059/3 "2017-07-21T07:18:49Z")
I changed date pattern Christian, still no help.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 7:21am UTC](https://discuss.elastic.co/t/help-required/94059/4 "2017-07-21T07:21:14Z")
What does your query look like now?
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:21am UTC](https://discuss.elastic.co/t/help-required/94059/5 "2017-07-21T07:21:47Z")
curl -XGET '[http://localhost:9200/201706/\_search](http://localhost:9200/201706/_search)' -d '{ "query" :{ "bool" : { "must" : [{ "match" : { "message": "isis"} }, { "range" :{ "created\_at" :{ "gte" :"2017/06/01", "lte" : "2017/06/30", "format" :"yyyy/mm/dd||yyyy"}}}]}}}'
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 7:24am UTC](https://discuss.elastic.co/t/help-required/94059/6 "2017-07-21T07:24:04Z")
According to the example it should be `MM` instead of `mm`.
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:24am UTC](https://discuss.elastic.co/t/help-required/94059/7 "2017-07-21T07:24:45Z")
I am getting 0 hits
{"took":11,"timed\_out":false,"\_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":0,"max\_score":null,"hits":[]}
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:25am UTC](https://discuss.elastic.co/t/help-required/94059/8 "2017-07-21T07:25:52Z")
Tried this query
curl -XGET '[http://localhost:9200/201706/\_search](http://localhost:9200/201706/_search)' -d '{ "query" :{ "bool" : { "must" : [{ "match" : { "message": "isis"} }, { "range" :{ "created\_at" :{ "gte" :"2017/06/01", "lte" : "2017/06/30", "format" :"yyyy/MM/dd||yyyy"}}}]}}}'
and got this result
{"took":11,"timed\_out":false,"\_shards":{"total":5,"successful":5,"failed":0},"hits":{"total":0,"max\_score":null,"hits":[]}}
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 7:32am UTC](https://discuss.elastic.co/t/help-required/94059/9 "2017-07-21T07:32:21Z")
What happens if you remove one of the 2 clauses, e.g. query just with filter or just with range query?
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:34am UTC](https://discuss.elastic.co/t/help-required/94059/10 "2017-07-21T07:34:14Z")
Then it works fine, but I want is to search a particular keyword in a particular date range.
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 7:38am UTC](https://discuss.elastic.co/t/help-required/94059/11 "2017-07-21T07:38:07Z")
When you search using just the filter, how many documents fit within the time range? Can you show a document that the full query should find?
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 7:56am UTC](https://discuss.elastic.co/t/help-required/94059/12 "2017-07-21T07:56:27Z")
Damn! Now even my range query is not working
curl -XGET 'localhost:9200/\_search?pretty' -d'
{
"query": {
"range" : {
"created\_at" : {
"gte": "2017-06-01",
"lte": "2017-06-30",
"format": "yyyy-MM/dd||yyyy"
}
}
}
}
'
---
### Author:  [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)
#### Post date: [July 21, 2017, 8:10am UTC](https://discuss.elastic.co/t/help-required/94059/13 "2017-07-21T08:10:28Z")
> [@Akhil\_Prashar](#):
>
> "yyyy-MM/dd||yyyy"
yyyy-MM-dd Try with this
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 21, 2017, 8:11am UTC](https://discuss.elastic.co/t/help-required/94059/14 "2017-07-21T08:11:36Z")
Index mapping
curl -XPOST '[http://localhost:9200/201706/facebook](http://localhost:9200/201706/facebook)' -d '{ "mappings" : { "facebook" : { "properties" : {
"feed\_id" : { "type" : "string"},
"id" : { "type" : "string"},
"type" : { "type" : "string"},
"message" : { "type" : "string"},
"created\_at" : { "type" : "date"},
"updated\_time" : { "type" : "date"},
"sentiment\_score" : { "type" : "string"},
"sentiment\_category" : { "type" : "string"},
"total\_shares" : { "type" : "string"},
"total\_likes" : { "type" : "string"},
"total\_comments" : { "type" : "string"},
"source" : { "type" : "string"},
"picture" : { "type" : "string"},
"media\_type" : { "type" : "string"},
"duration" : { "type" : "string"},
"name" : { "type" : "string"},
"fb\_user\_id" : { "type" : "string"}
}
}
}
}'
---
### Author:  [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)
#### Post date: [July 21, 2017, 8:12am UTC](https://discuss.elastic.co/t/help-required/94059/15 "2017-07-21T08:12:03Z")
Can you show me a sample doc available in the index
---
### Author:  [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)
#### Post date: [July 21, 2017, 8:15am UTC](https://discuss.elastic.co/t/help-required/94059/16 "2017-07-21T08:15:39Z")
I tried this and it works:
```auto
curl -XPUT 127.0.0.1:9200/rangetest/test/1 -d '{"message" : "aaa bbb ccc", "created_at" : "2017-06-15T14:00:00"}'
sleep 1
curl -XGET 'http://localhost:9200/test/test/_search' -d '{ "query" :{ "bool" : { "must" : [{ "match" : { "message": "bbb"} }, { "range" :{ "created_at" :{ "gte" :"2017/06/01", "lte" : "2017/06/30", "format" :"yyyy/MM/dd"}}}]}}}'
```
---
### Author:  [@Ravi\_Shanker\_Reddy](https://discuss.elastic.co/u/Ravi_Shanker_Reddy)
#### Post date: [July 21, 2017, 9:08am UTC](https://discuss.elastic.co/t/help-required/94059/17 "2017-07-21T09:08:09Z")
Can you show your index mapping once???
---
### Author:  [@Akhil\_Prashar](https://discuss.elastic.co/u/Akhil_Prashar)
#### Post date: [July 24, 2017, 8:17am UTC](https://discuss.elastic.co/t/help-required/94059/18 "2017-07-24T08:17:44Z")
Sorry for the delay Ravi
> [@Akhil\_Prashar](#):
>
> Index mapping
> curl -XPOST '[http://localhost:9200/201706/facebook](http://localhost:9200/201706/facebook)' -d '{ "mappings" : { "facebook" : { "properties" : {
> "feed\_id" : { "type" : "string"},
> "id" : { "type" : "string"},
> "type" : { "type" : "string"},
> "message" : { "type" : "string"},
> "created\_at" : { "type" : "date"},
> "updated\_time" : { "type" : "date"},
> "sentiment\_score" : { "type" : "string"},
> "sentiment\_category" : { "type" : "string"},
> "total\_shares" : { "type" : "string"},
> "total\_likes" : { "type" : "string"},
> "total\_comments" : { "type" : "string"},
> "source" : { "type" : "string"},
> "picture" : { "type" : "string"},
> "media\_type" : { "type" : "string"},
> "duration" : { "type" : "string"},
> "name" : { "type" : "string"},
> "fb\_user\_id" : { "type" : "string"}
> }
> }
> }
> }'
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 21, 2017, 8:18am UTC](https://discuss.elastic.co/t/help-required/94059/19 "2017-08-21T08:18:28Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.