# Not able to filter from timestamp

**URL:** https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692
**Category:** Kibana
**Created:** [November 8, 2023, 10:00am UTC](https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692 "2023-11-08T10:00:09Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![shivakrishnaadduri](https://avatars.discourse-cdn.com/v4/letter/s/67e7ee/32.png) [@shivakrishnaadduri](https://discuss.elastic.co/u/shivakrishnaadduri)
#### Post date: [November 8, 2023, 10:00am UTC](https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692/1 "2023-11-08T10:00:09Z")

</div>

I am trying to filter last 10 or some x minutes of data based on values in timestamp  
Here is my timestamp data : ` "timestamp": "2023-11-08 14:28:06",`  
and mapping info

```auto
 "timestamp": {
          "type": "date",
          "format": "yyyy-MM-dd HH:mm:ss"
        }

```

I am using this query to filter

```auto

  "query": {
    "range": {
      "timestamp": {
        "gte": "now-10m/m",
        "lte": "now/m",
        "format": "yyyy-MM-dd HH:mm:ss"
      }
    }
  }

```

what ever the timeframe I change it's always giving me the empty set.  
any help would be apricated . Thank you.

---

<div class="post-metadata">

### Author: ![Priscilla\_Parodi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/priscilla_parodi/32/43047_2.png) [@Priscilla\_Parodi](https://discuss.elastic.co/u/Priscilla_Parodi)
#### Post date: [December 2, 2023, 6:12pm UTC](https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692/2 "2023-12-02T18:12:26Z")

</div>

Hello @shivakrishnaadduri,

Welcome to the community!

When you say you're trying to filter, do you mean in Kibana Discover?

If so, how are you doing it? Are you adding a Query DSL filter?

 ![Image 11-30-23 at 4.04 PM](https://us1.discourse-cdn.com/elastic/original/3X/1/0/10fce9d887cb08f196d9930adfdebbf6ab1e9bb8.jpeg)

Are there any error messages?

---

<div class="post-metadata">

### Author: ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)
#### Post date: [December 2, 2023, 9:46pm UTC](https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692/3 "2023-12-02T21:46:44Z")

</div>

Are you sure you actually have data from 10 minutes ago? 🙂

---

<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: [December 30, 2023, 9:46pm UTC](https://discuss.elastic.co/t/not-able-to-filter-from-timestamp/346692/4 "2023-12-30T21:46:49Z")

</div>

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