# Date format incorrect results

**URL:** <https://discuss.elastic.co/t/date-format-incorrect-results/40643>\
**Category:** Elasticsearch\
**Created:** [February 1, 2016, 3:25pm UTC](https://discuss.elastic.co/t/date-format-incorrect-results/40643 "2016-02-01T15:25:56Z")\
**Posts on this page:** 1\
**Showing post:** 10

<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 5, 2016, 3:34pm UTC](https://discuss.elastic.co/t/date-format-incorrect-results/40643/10 "2016-02-05T15:34:07Z")

</div>

I told you that you should try first with an example without using any client. So you make sure that:

1. you understand how elasticsearch works
2. where your error is coming from

So here is a full example which works:

```auto
DELETE index
PUT index
PUT index/doc/_mapping
{
  "properties": {
    "date": {
      "type": "date",
      "format": "yyyy-MM-dd HH:mm:ss"
    }
  }
}
PUT index/doc/1
{
  "date": "2016-12-01 13:00:59"
}
GET index/_search
{
  "query": {
    "range": {
      "date": {
        "gte": "2016-12-01 10:00:00",
        "lte": "2016-12-01 14:00:00"
      }
    }
  }
}

```

---

_[View the full topic](https://discuss.elastic.co/t/date-format-incorrect-results/40643)._