# Deletion of Elasticsearch index data of particular dates or retaining since 15 days

**URL:** <https://discuss.elastic.co/t/deletion-of-elasticsearch-index-data-of-particular-dates-or-retaining-since-15-days/198893>\
**Category:** Elasticsearch\
**Created:** [September 10, 2019, 12:11pm UTC](https://discuss.elastic.co/t/deletion-of-elasticsearch-index-data-of-particular-dates-or-retaining-since-15-days/198893 "2019-09-10T12:11:16Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Deepakny](https://avatars.discourse-cdn.com/v4/letter/d/5fc32e/32.png) [@Deepakny](https://discuss.elastic.co/u/Deepakny)\
**Post date:** [September 10, 2019, 12:11pm UTC](https://discuss.elastic.co/t/deletion-of-elasticsearch-index-data-of-particular-dates-or-retaining-since-15-days/198893/1 "2019-09-10T12:11:16Z")

</div>

I have created an elasticsearch (version -6.3) domain in AWS and there is only one index(mindtrace) to which data gets streamed. I need to delete the data in the index for particular time and i tried using below delete query

POST mindtrace/\_delete\_by\_query  
{  
"query": {  
"range" : {  
"@timestamp" : {  
"gte" : "2019-08-15T00:00:00Z",  
"lte" : "2019-08-20T00:00:00Z",  
"format": "yyyy-MM-dd'T'HH:mm:ssz"  
}  
}  
}  
}

Once i run the query in DEV Tools of kibana I get the below results  
{  
"took": 6,  
"timed\_out": false,  
"total": 0,  
"deleted": 0,  
"batches": 0,  
"version\_conflicts": 0,  
"noops": 0,  
"retries": {  
"bulk": 0,  
"search": 0  
},  
"throttled\_millis": 0,  
"requests\_per\_second": -1,  
"throttled\_until\_millis": 0,  
"failures":   
}

Deleted shows 0. No documents are deleted

Please help me with this to delete index data for particular dates or retaining since 15 days and deleting remaining data

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 8, 2019, 12:11pm UTC](https://discuss.elastic.co/t/deletion-of-elasticsearch-index-data-of-particular-dates-or-retaining-since-15-days/198893/2 "2019-10-08T12:11:17Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.