Delete documents of an index older than 7 days

Elastic Stack Elasticsearch
1

I want to delete documents from my index ''index_name" which are older than 7 days.
The field I want to use is not @timestamp and is another field "date" in that index.

I am not sure of the DELETE QUERY.

Please help

2

you can use the delete query along with time range

3

20180911_125212
20180911_125212.jpg3120×1545 2.06 MB

I am using the query in screenshot. The only problem is date less than : now-5 is deleting documents as now-4. Suppose if I run it today 11th Sept it is deleting docs of 6th September too.

4

make it now-6d and try to run
or moreover you can use it also

"range": {
    "date": {
        "gte": "2015-11-01",
        "lte": "2015-11-30"
    }
}