# Elasticsearch date range query using java api
**URL:** https://discuss.elastic.co/t/elasticsearch-date-range-query-using-java-api/67318
**Category:** Elasticsearch
**Created:** [November 28, 2016, 9:02am UTC](https://discuss.elastic.co/t/elasticsearch-date-range-query-using-java-api/67318 "2016-11-28T09:02:49Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@aniketpatil](https://discuss.elastic.co/u/aniketpatil)
#### Post date: [November 28, 2016, 9:02am UTC](https://discuss.elastic.co/t/elasticsearch-date-range-query-using-java-api/67318/1 "2016-11-28T09:02:49Z")
I am using elasticsearch 1.5.2 and written query to get status count for last x days.
```
SearchRequest requestQuery =
Requests.searchRequest(ConstantsValue.indexName)
.types(ConstantsValue._Type)
.source("{size:999999,"
+ "\"_source\" : "
+ "[\"DTCREATED\", \"STATUS\"]"
+", \"query\": {"
+" \"filtered\": {"
+" \"filter\": {"
+ "\"range\": { \"DTCREATED\": { \"gte\": \"now-30d/d\" }}"
+"}}}"
+ ",\"aggs\": "
+ "{\"group_by_STATUS\": {\"terms\": {\"field\": \"STATUS\"},"
+ "\"aggs\" : "
+ "{\"group_by_DATE\" : {\"date_histogram\" : "
+ "{\"field\" : \"DTCREATED\", \"interval\" : \"day\","
+ "\"format\" : \"yyyy-MM-dd\" },"
+ "\"aggs\" : "
+ "{\"grades_count\" : { \"value_count\" : { \"field\" : \"STATUS\" } }}}}}}}");
```
Now I want to use date range like data should be fetched within x to y date. How can I change above query to get expected result. DTCREATED field contains both date and time.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 26, 2016, 9:03am UTC](https://discuss.elastic.co/t/elasticsearch-date-range-query-using-java-api/67318/2 "2016-12-26T09:03:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.