# Unable to search number and date in kibana Discover TAB

**URL:** <https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624>\
**Category:** Kibana\
**Created:** [September 15, 2016, 3:46pm UTC](https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624 "2016-09-15T15:46:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![balubollam](https://avatars.discourse-cdn.com/v4/letter/b/a587f6/32.png) [@balubollam](https://discuss.elastic.co/u/balubollam)\
**Post date:** [September 15, 2016, 3:46pm UTC](https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624/1 "2016-09-15T15:46:17Z")

</div>

Hi everyone,

I am using kibana4.5.4  
elasticsearch 2.3.3

Iam trying to search data and date with regular expression in the disover tab of kibana

But we have data like  
"url":"/abc/bcd/gcd/sample.jpg" //not-analyzed string  
//Able to access by giving url:\*jpg in discover tab

But we have also data like  
"url":"/abc/bcd/gcd/11K **But** This we cant access by url:\*K

Even the date format(dateOptinalTime format)  
"http\_timestamp": "2016-09-08 12:27:31" ///Even this not able access in discover tab in this below way "http\_timestamp": "2016-09-08 12:27:31"

Please anyone help me how to access this in discover tab

---

<div class="post-metadata">

**Author:** ![tylersmalley](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tylersmalley/32/8833_2.png) [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)\
**Post date:** [September 16, 2016, 6:26am UTC](https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624/2 "2016-09-16T06:26:05Z")

</div>

Using the data you provided, I was able to successfully query the records using a wildcard.

In the example of "/abc/bcd/gcd/11K", make sure that there is no whitespace after "K". When searching on the timestamp, you will need to encapsulate the value in quotes since it contains a colon `http_timestamp:"*12:27:31"`

---

<div class="post-metadata">

**Author:** ![balubollam](https://avatars.discourse-cdn.com/v4/letter/b/a587f6/32.png) [@balubollam](https://discuss.elastic.co/u/balubollam)\
**Post date:** [September 20, 2016, 5:32am UTC](https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624/3 "2016-09-20T05:32:59Z")

</div>

Hi tsmalley,

Thank for your reply ...But we are getting invalid format..

..  
..  
..  
Without regex it is working like this http\_timestamp: "2016-09-08 12:27:31"

..  
..  
BUt we have requirement like we need to get only 2010 years should be displayed..

For that trying http\_timestamp:"2010\*"

..  
..  
PLease help me out for getting search query for specific year

---

<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:** [July 6, 2017, 1:38pm UTC](https://discuss.elastic.co/t/unable-to-search-number-and-date-in-kibana-discover-tab/60624/4 "2017-07-06T13:38:42Z")

</div>