# NumberFormatException in date range aggregation query **URL:** \ **Category:** Elasticsearch\ **Created:** [May 12, 2017, 11:34am UTC](https://discuss.elastic.co/t/numberformatexception-in-date-range-aggregation-query/85554 "2017-05-12T11:34:14Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![Newbie111985](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/newbie111985/32/17561_2.png) [@Newbie111985](https://discuss.elastic.co/u/Newbie111985)\ **Post date:** [May 12, 2017, 11:34am UTC](https://discuss.elastic.co/t/numberformatexception-in-date-range-aggregation-query/85554/1 "2017-05-12T11:34:14Z")
I have below date range aggregation query: "Last\_Modified\_Date": { "range": { "field": "lastmodified", "format": "yyyy-MM-dd", "ranges": [ { "to": "now/y" }, { "from": "now/y" }, { "from": "now-30d/d", "to": "now/d" }, { "from": "now-7d/d", "to": "now/d" }, { "from": "now/d", "to": "now+1d/d" } ] } } and this query seems to work fine. But I see below exception in logs: org.elasticsearch.transport.RemoteTransportException: [[examplehost.com](http://examplehost.com)][10.248.9.42:9300][indices:data/read/search[phase/query]] Caused by: java.lang.NumberFormatException: For input string: "now/y" at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:2043) ~[?:1.8.0\_121] at sun.misc.FloatingDecimal.parseDouble(FloatingDecimal.java:110) ~[?:1.8.0\_121] at java.lang.Double.parseDouble(Double.java:538) ~[?:1.8.0\_121] at org.elasticsearch.search.DocValueFormat$1.parseDouble(DocValueFormat.java:115) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.bucket.range.RangeAggregator$Range.process(RangeAggregator.java:124) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.bucket.range.AbstractRangeBuilder.processRanges(AbstractRangeBuilder.java:69) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.bucket.range.RangeAggregationBuilder.innerBuild(RangeAggregationBuilder.java:118) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.bucket.range.RangeAggregationBuilder.innerBuild(RangeAggregationBuilder.java:33) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.support.ValuesSourceAggregationBuilder.doBuild(ValuesSourceAggregationBuilder.java:300) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.support.ValuesSourceAggregationBuilder.doBuild(ValuesSourceAggregationBuilder.java:49) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.AbstractAggregationBuilder.build(AbstractAggregationBuilder.java:126) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.aggregations.AggregatorFactories$Builder.build(AggregatorFactories.java:211) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.SearchService.parseSource(SearchService.java:731) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.SearchService.createContext(SearchService.java:553) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.SearchService.createAndPutContext(SearchService.java:529) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.search.SearchService.executeQueryPhase(SearchService.java:264) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.action.search.SearchTransportService$6.messageReceived(SearchTransportService.java:300) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.action.search.SearchTransportService$6.messageReceived(SearchTransportService.java:297) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.transport.RequestHandlerRegistry.processMessageReceived(RequestHandlerRegistry.java:69) ~[elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.transport.TransportService$6.doRun(TransportService.java:577) [elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.common.util.concurrent.ThreadContext$ContextPreservingAbstractRunnable.doRun(ThreadContext.java:527) [elasticsearch-5.1.2.jar:5.1.2] at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:37) [elasticsearch-5.1.2.jar:5.1.2] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0\_121] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0\_121] at java.lang.Thread.run(Thread.java:745) [?:1.8.0\_121] lastmodified property mapping is as follows: "lastmodified": { "type": "date", "format": "yyyy-MM-dd'T'HH:mm:ss.SSS'Z'" } What I am doing wrong here? or can this exception be ignored? Thanks in advance. ---
**Author:** ![lwintergerst](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lwintergerst/32/18164_2.png) [@lwintergerst](https://discuss.elastic.co/u/lwintergerst)\ **Post date:** [May 12, 2017, 12:25pm UTC](https://discuss.elastic.co/t/numberformatexception-in-date-range-aggregation-query/85554/2 "2017-05-12T12:25:26Z")
Hello, you are using a "range" aggregation instead of the "date\_range" aggregation. Just replace that part of your aggregation and it will work 🙂 Let me know if that works or if you need any more help, Luca ---
**Author:** ![Newbie111985](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/newbie111985/32/17561_2.png) [@Newbie111985](https://discuss.elastic.co/u/Newbie111985)\ **Post date:** [May 12, 2017, 5:59pm UTC](https://discuss.elastic.co/t/numberformatexception-in-date-range-aggregation-query/85554/3 "2017-05-12T17:59:03Z")
Thanks for your help. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 9, 2017, 6:06pm UTC](https://discuss.elastic.co/t/numberformatexception-in-date-range-aggregation-query/85554/4 "2017-06-09T18:06:00Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.