# Kibana Search on field endTime not working

**URL:** <https://discuss.elastic.co/t/kibana-search-on-field-endtime-not-working/326318>\
**Category:** Kibana\
**Created:** [February 23, 2023, 11:37am UTC](https://discuss.elastic.co/t/kibana-search-on-field-endtime-not-working/326318 "2023-02-23T11:37:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![garmy](https://avatars.discourse-cdn.com/v4/letter/g/b487fb/32.png) [@garmy](https://discuss.elastic.co/u/garmy)\
**Post date:** [February 23, 2023, 11:37am UTC](https://discuss.elastic.co/t/kibana-search-on-field-endtime-not-working/326318/1 "2023-02-23T11:37:27Z")

</div>

Hi gang,

Trying to identify documents that have a time field called "endTime" \>= future times..... since this field is a UTC Time field, some may, and do have 'Future' dates and those are what I want to see (as well as systems with misconfigured NTP settings). How is this accomplished? Here is one of the queries that i have unsuccessfully tried:  
Lucene: endTime=\>"Feb 23, 2023 @ 11:34:00.000"  
I have also tried various regexp attempts as well.

TIA,

Greg

---

<div class="post-metadata">

**Author:** ![eMitch](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/emitch/32/93607_2.png) [@eMitch](https://discuss.elastic.co/u/eMitch)\
**Post date:** [February 23, 2023, 6:04pm UTC](https://discuss.elastic.co/t/kibana-search-on-field-endtime-not-working/326318/2 "2023-02-23T18:04:56Z")

</div>

Hi @garmy and welcome to the community!

Querying dates can be confusing sometimes.

What does the mapping for `endTime` look like?  
Are you querying through kibana or via the API?

Try this in Kibana and see what returns:  
`endTime >= "2023-02-23T11:34:00.000Z"`

---

<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:** [March 23, 2023, 6:05pm UTC](https://discuss.elastic.co/t/kibana-search-on-field-endtime-not-working/326318/3 "2023-03-23T18:05:28Z")

</div>

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