# Query sur date du jour
**URL:** https://discuss.elastic.co/t/query-sur-date-du-jour/165606
**Category:** Discussions en français
**Created:** [January 24, 2019, 12:43pm UTC](https://discuss.elastic.co/t/query-sur-date-du-jour/165606 "2019-01-24T12:43:53Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Michel](https://discuss.elastic.co/u/Michel)
#### Post date: [January 24, 2019, 12:43pm UTC](https://discuss.elastic.co/t/query-sur-date-du-jour/165606/1 "2019-01-24T12:43:53Z")
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"
}
}
},
{
"term": {
"target": {
"value": "homer"
}
}
},
{
"term": {
"slo_violations": {
"value": "1"
}
}
}
]
}
}
}
```
---
### Author:  [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [January 25, 2019, 12:07pm UTC](https://discuss.elastic.co/t/query-sur-date-du-jour/165606/2 "2019-01-25T12:07:35Z")
Essaye avec
```
"gte": "now/d+7h"
```
Non testé mais une idée en lisant cette page: [https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-range-query.html](https://www.elastic.co/guide/en/elasticsearch/reference/6.5/query-dsl-range-query.html)
Et [https://www.elastic.co/guide/en/elasticsearch/reference/6.5/common-options.html#date-math](https://www.elastic.co/guide/en/elasticsearch/reference/6.5/common-options.html#date-math)
---
### Author:  [@Michel](https://discuss.elastic.co/u/Michel)
#### Post date: [January 25, 2019, 12:25pm UTC](https://discuss.elastic.co/t/query-sur-date-du-jour/165606/3 "2019-01-25T12:25:04Z")
Merci beaucoup.
Cela fonctionne parfaitement.
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [February 22, 2019, 12:25pm UTC](https://discuss.elastic.co/t/query-sur-date-du-jour/165606/4 "2019-02-22T12:25:05Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.