# Date range filter using strict\_date\_time\_no\_millis format failing

**URL:** <https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255>\
**Category:** Elasticsearch\
**Created:** [July 22, 2020, 9:17pm UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255 "2020-07-22T21:17:18Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![russinholi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/russinholi/32/25665_2.png) [@russinholi](https://discuss.elastic.co/u/russinholi)\
**Post date:** [July 22, 2020, 9:17pm UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255/1 "2020-07-22T21:17:18Z")

</div>

Hi all, I'm porting a query of an old app we have, from ES2.0 to ES7.8, and I'm getting this error:

`failed to parse date field [2020-07-23T02:59:59+0000] with format [strict_date_time_no_millis]`

while running a query with this range filter:  
`{"range": { "activation_date":{"gte": "2016-11-09T02:00:00+0000", "lte":"2020-07-23T02:59:59+0000"}}}`

the activation\_date field is mapped as:

```auto
"activation_date" : {
       "type" : "date",
      "format" : "strict_date_time_no_millis"
  }

```

But if I change the `lte` part of the range to `2020-07-23T02:59:59Z` the query works.

Any hint of what is the problem?

I'm using a docker image of ES7.8.

---

<div class="post-metadata">

**Author:** ![Vinayak\_Sapre](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vinayak_sapre/32/45939_2.png) [@Vinayak\_Sapre](https://discuss.elastic.co/u/Vinayak_Sapre)\
**Post date:** [July 23, 2020, 6:08am UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255/2 "2020-07-23T06:08:19Z")

</div>

@russinholi  
Try format `yyyy-MM-dd'T'HH:mm:ssZ`.

---

<div class="post-metadata">

**Author:** ![russinholi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/russinholi/32/25665_2.png) [@russinholi](https://discuss.elastic.co/u/russinholi)\
**Post date:** [July 23, 2020, 2:31pm UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255/3 "2020-07-23T14:31:12Z")

</div>

Thanks for you answer Vinayak\_Sapre, and yes using this format works, but I'm only wondering why this happens only on `lte` value and not on `gte`.

The same happens if I use it on query string like:  
`((something) AND activation_date:[2016-11-09T02:00:00+0000 TO 2020-07-23T02:59:59+0000])`  
the same error is raised, but if I change the `TO` part to `yyyy-MM-dd'T'HH:mm:ssZ`format like:  
`((something) AND activation_date:[2016-11-09T02:00:00+0000 TO 2020-07-23T02:59:59Z])`  
it works.

So why the rage limit needs to be in `yyyy-MM-dd'T'HH:mm:ssZ`format?

---

<div class="post-metadata">

**Author:** ![Vinayak\_Sapre](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/vinayak_sapre/32/45939_2.png) [@Vinayak\_Sapre](https://discuss.elastic.co/u/Vinayak_Sapre)\
**Post date:** [July 23, 2020, 5:10pm UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255/4 "2020-07-23T17:10:23Z")

</div>

@russinholi  
ES moved to java date api in 7.0. Previous versions used Joda time. I have seen many posts with inconsistencies with format. [https://www.elastic.co/guide/en/elasticsearch/reference/7.x/migrate-to-java-time.html](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/migrate-to-java-time.html)

I will do some debugging.at some point to figure out. But I don't know exact reason.

see [Date parsing error in Elasticsearch 7.1](https://discuss.elastic.co/t/date-parsing-error-in-elasticsearch-7-1/240607)

---

<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:** [August 20, 2020, 5:10pm UTC](https://discuss.elastic.co/t/date-range-filter-using-strict-date-time-no-millis-format-failing/242255/5 "2020-08-20T17:10:25Z")

</div>

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