# Date type question : Get Documents by Year
**URL:** https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274
**Category:** Elasticsearch
**Created:** [August 1, 2017, 3:47am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274 "2017-08-01T03:47:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@abhikrbng](https://discuss.elastic.co/u/abhikrbng)
#### Post date: [August 1, 2017, 3:47am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274/1 "2017-08-01T03:47:22Z")
I have a DATE field in an index with
**"type"** : "date" &
**"format"** : "strict\_date\_optional\_time||epoch\_millis"
I need to get all the Documents in a mentioned year(say : return all documents whose date field has year 2017)
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [August 1, 2017, 3:49am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274/2 "2017-08-01T03:49:23Z")
Should be easy enough, what have you tried?
---
### Author:  [@abhikrbng](https://discuss.elastic.co/u/abhikrbng)
#### Post date: [August 1, 2017, 4:04am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274/3 "2017-08-01T04:04:44Z")
Its working in case of query string :
i) [http://localhost:9200/\_search?q=](http://localhost:9200/_search?q=)_2017_
But
when i am finding the same with the attibuteName , its returning null .Dont know why?
ii)[http://localhost:9200/\_search?q=mydateAttributeName:](http://localhost:9200/_search?q=mydateAttributeName:)_2017_
I cant use i) , cause the any other field in the document can also have 2017 as text.
Is it possible to get it done using Query-DSL?
- mydateAttributeName = 2017-07-30T18:30:00.000Z
---
### Author:  [@abhikrbng](https://discuss.elastic.co/u/abhikrbng)
#### Post date: [August 1, 2017, 4:44am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274/5 "2017-08-01T04:44:10Z")
" **range-query**" did the job 🙂
To get the records in year 2017 using query-dsl ,
{
"query": {
"range": {
"myDateAttributeName": {
"gte": "2016-12-31T00:00:00.000Z",
"lte": "2018-01-01T00:00:00.000Z"
}
}
}
}
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [August 29, 2017, 4:44am UTC](https://discuss.elastic.co/t/date-type-question-get-documents-by-year/95274/6 "2017-08-29T04:44:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.