# Query with today date
**URL:** https://discuss.elastic.co/t/query-with-today-date/165572
**Category:** Elasticsearch
**Created:** [January 24, 2019, 10:08am UTC](https://discuss.elastic.co/t/query-with-today-date/165572 "2019-01-24T10:08:27Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Michel](https://discuss.elastic.co/u/Michel)
#### Post date: [January 24, 2019, 10:08am UTC](https://discuss.elastic.co/t/query-with-today-date/165572/1 "2019-01-24T10:08:27Z")
Hello, I want to search on a date area to extract the data of the day from 7 hours, I hard coded, but I would like the day depends on the date I do the extraction , Thank you for your help.
GET /\_search
{
"query": {
"bool": {
"must": [
{
"range": {
"datetime": {
"gte": "2019-01-24T07"
}
}
},
{
"term": {
"target": {
"value": "homer"
}
}
},
{
"term": {
"slo\_violations": {
"value": "1"
}
}
}
]
}
}
}
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 24, 2019, 10:22am UTC](https://discuss.elastic.co/t/query-with-today-date/165572/2 "2019-01-24T10:22:52Z")
Read [https://www.elastic.co/guide/en/elasticsearch/reference/6.6/query-dsl-range-query.html#ranges-on-dates](https://www.elastic.co/guide/en/elasticsearch/reference/6.6/query-dsl-range-query.html#ranges-on-dates)
---
### Author:  [@Michel](https://discuss.elastic.co/u/Michel)
#### Post date: [January 24, 2019, 10:41am UTC](https://discuss.elastic.co/t/query-with-today-date/165572/3 "2019-01-24T10:41:22Z")
Thanks but I am french and google translation is not very good, I can not understand how to do, can you change my code please.
Michel.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 24, 2019, 10:53am UTC](https://discuss.elastic.co/t/query-with-today-date/165572/4 "2019-01-24T10:53:43Z")
I'm french too. You can also ask in #in-your-native-tongue:discussions-en-francais en français if you wish.
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 25, 2019, 12:47pm UTC](https://discuss.elastic.co/t/query-with-today-date/165572/5 "2019-01-25T12:47:14Z")
Closing the loop here. The answer was:
```auto
"gte": "now/d+7h"
```
> [@Query sur date du jour](https://discuss.elastic.co/t/query-sur-date-du-jour/165606):
>
> Bonjour à tous, je cherche à effectuer une extraction tout au long de la journée, dont le principal critère est la date du jour + 7 heures, dans l'exemple ci-dessous j'ai codé la date/heure en dur ("2019-01-24T07"), mais je souhaiterai que celle-ci soit fonction de la date du jour. Comment coder cela, d'avance merci de votre aide. GET /\_search { "query": { "bool": { "must": [ { "range": { "datetime": { "gte": "2019-01-24T07" } …
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 22, 2019, 12:47pm UTC](https://discuss.elastic.co/t/query-with-today-date/165572/6 "2019-02-22T12:47:16Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.