title: ElasticSearch - Range filter by date is not working,
body: <p>I'm trying to filter a query using range by date but it's not working. If i use <strong>gt</strong>, <strong>gte</strong>, <strong>lt</strong>, <strong>lte</strong> it returns zero results. If i use only <strong>gt</strong> or <strong>lt</strong>, it returns some results but the filter is not working.</p>
  
  <p>I've checked datatype on uri <a href="http://mydomain.local:9200/logstash-2014.09.09/_mapping?pretty=true" rel="nofollow">http://mydomain.local:9200/logstash-2014.09.09/_mapping?pretty=true</a> the field type is correct:</p>
  
  <pre><code>"original" : {
      "type" : "date",
      "format" : "dateOptionalTime"
  }
  </code></pre>
  
  <p>Here is an example of a result that i have indexed in ElasticSearch:</p>
  
  <pre><code>{
      "_index" : "logstash-2014.09.08",
      "_type" : "iis",
      "_id" : "wxtnfpyjR4u7dhwlEAWevw",
      "_score" : 1.0,
      "_source":{"@version":"1","@timestamp":"2014-09-08T20:55:46.460Z",
                 "type":"iis","original":"14-09-08 17:39:58"}
  }
  </code></pre>
  
  <p>And here is how i'm trying to perform a query:</p>
  
  <pre><code>{
      "query" : {
          "filtered" : {
              "filter" : {
                  "range" : {
                      "original" : {
                          "gt" : "14-09-10"
                      }
                  }
              }
          }
      }
  }
  </code></pre>
  
  <p>Anyone knows what is wrong on my query? Why it returns some results if i don't have any date greater than today ( 2014-09-09 )?</p>