# Question in elastic search to get specific records with specific date and time range
**URL:** https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217
**Category:** Elasticsearch
**Created:** [January 15, 2021, 7:43am UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217 "2021-01-15T07:43:33Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@Kin\_Wan](https://discuss.elastic.co/u/Kin_Wan)
#### Post date: [January 15, 2021, 7:43am UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/1 "2021-01-15T07:43:33Z")
Hello all, I would like to perform a query to get last weeks records on our log which the record are within Mon-Fri from (19:00-07:00) and Sat from (15:00-00:00) and full day on Sunday. How should I write the query? Thanks.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 17, 2021, 10:53pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/2 "2021-01-17T22:53:31Z")
Welcome to our community! 😃
Does [https://www.elastic.co/guide/en/elasticsearch/reference/7.10/query-dsl-range-query.html#ranges-on-dates](https://www.elastic.co/guide/en/elasticsearch/reference/7.10/query-dsl-range-query.html#ranges-on-dates) help? What have you tried so far?
---
### Author:  [@Kin\_Wan](https://discuss.elastic.co/u/Kin_Wan)
#### Post date: [January 20, 2021, 6:48am UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/3 "2021-01-20T06:48:38Z")
I tried to get the records between 2021-01-07 to 2021-01-13 with the below commands but it fails.
```auto
GET /project.sli-app01.*/_search
{
"query": {
"bool": {
"must": {
"match": {
"message": "successLoginID"
}
},
"filter": {
"bool": {
"must": [
{
"range": {
"@timestamp": {
"format": "YYYY-MM-DD",
"time_zone": "+08:00",
"gte":"2021-01-07",
"lt": "2021-01-13"
}
}},{
"range": {
"@timestamp": {
"format": "HH:mm",
"time_zone": "+08:00",
"gte":"09:00",
"lt": "18:00"
}
}
}
]
}
}
}
},
"size": 1000,
"_source": [
"@timestamp",
"level",
"message",
"kubernetes.container_name"
]
}
```
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [January 20, 2021, 8:21pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/4 "2021-01-20T20:21:01Z")
Fails how?
---
### Author:  [@Kin\_Wan](https://discuss.elastic.co/u/Kin_Wan)
#### Post date: [January 25, 2021, 4:23am UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/5 "2021-01-25T04:23:46Z")
No result found, but it is expected that there should have records.
---
### Author:  [@Kin\_Wan](https://discuss.elastic.co/u/Kin_Wan)
#### Post date: [January 28, 2021, 6:57am UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/6 "2021-01-28T06:57:37Z")
Anyone has idea? Thanks.
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [February 1, 2021, 11:14pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/7 "2021-02-01T23:14:03Z")
Have you tried finding some of these documents in Discover in Kibana, using that same timeframe?
---
### Author:  [@Kin\_Wan](https://discuss.elastic.co/u/Kin_Wan)
#### Post date: [February 5, 2021, 2:39pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/8 "2021-02-05T14:39:21Z")
Yes and result can be found
---
### Author:  [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [February 6, 2021, 11:32pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/9 "2021-02-06T23:32:28Z")
Ok, if you click on Inspect in the top right, it'll show you the request it sent. Copy that and you should get results.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 6, 2021, 11:32pm UTC](https://discuss.elastic.co/t/question-in-elastic-search-to-get-specific-records-with-specific-date-and-time-range/261217/10 "2021-03-06T23:32:40Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.