# Elasticsearch Range Filter

**URL:** <https://discuss.elastic.co/t/elasticsearch-range-filter/40495>\
**Category:** Elasticsearch\
**Created:** [January 29, 2016, 3:36pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495 "2016-01-29T15:36:53Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [January 29, 2016, 3:36pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/1 "2016-01-29T15:36:53Z")

</div>

Hi,  
I am using PHP 5.1, Mysql and Elasticsearch 2.1.  
I indexed my datas to Elasticsearch from Mysql .  
I am doing filter and query now. I have date field.  
I want to do date range filter and query.

My codes:

unset($filter\_date);  
if(isset($\_GET['date\_gte'])){  
$filter\_date['range']['date']['gte']=$\_GET['date\_gte'];  
$filter\_date['range']['date']['lte']=$\_GET['date\_lte'];  
}  
if(is\_array($filter\_date)){  
$searchParams['body']['query']=$filter\_datei;  
}

My query on URL:  
10.0.2.15:8080/filters.php?date\_gte=2013-31-01 00:00:00&date\_lte=2015-31-01

Unfortunately it dosen't return results. Please help me

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [January 29, 2016, 5:17pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/2 "2016-01-29T17:17:25Z")

</div>

Does it work with `date_gte=2013-01-01&date_lte=2015-01-01`?

Make sure your date format is the same as defined in the mapping.

---

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [February 1, 2016, 7:28am UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/3 "2016-02-01T07:28:01Z")

</div>

> [@dadoonet](#):
>
> Make sure your date format is the same as defined in the mapping.

Date mapping code:

$myTypeMapping['properties']['date']['type']='date';  
$myTypeMapping['properties']['date']['index']='not\_analyzed';

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [February 1, 2016, 7:41am UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/4 "2016-02-01T07:41:18Z")

</div>

Not the same format as the query you sent. Read the doc about date mapping and its default format.

---

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [February 1, 2016, 11:58am UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/5 "2016-02-01T11:58:05Z")

</div>

> [@dadoonet](#):
>
> Not the same format as the query you sent. Read the doc about date mapping and its default format.

I read.

$myTypeMapping['properties']['date']['type']='date';  
$myTypeMapping['properties']['date']['index']='analyzed';  
$myTypeMapping['properties']['date']['format']='yyyy-MM-dd';

Is it true?

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [February 1, 2016, 12:23pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/6 "2016-02-01T12:23:54Z")

</div>

Try with:

> [@dadoonet](#):
>
> ```
> date_gte=2013-01-01&date_lte=2015-01-01?
> 
> ```

---

<div class="post-metadata">

**Author:** ![Hilal](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/hilal/32/7684_2.png) [@Hilal](https://discuss.elastic.co/u/Hilal)\
**Post date:** [February 1, 2016, 1:17pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/7 "2016-02-01T13:17:14Z")

</div>

ok It is done Thank you

---

<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 5, 2017, 11:19pm UTC](https://discuss.elastic.co/t/elasticsearch-range-filter/40495/8 "2017-07-05T23:19:53Z")

</div>