# Date Range filter in data table Kibana 5.4.1 **URL:** \ **Category:** Kibana\ **Created:** [July 28, 2017, 9:29pm UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017 "2017-07-28T21:29:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Louie\_Hernandez](https://avatars.discourse-cdn.com/v4/letter/l/f14d63/32.png) [@Louie\_Hernandez](https://discuss.elastic.co/u/Louie_Hernandez)\ **Post date:** [July 28, 2017, 9:29pm UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/1 "2017-07-28T21:29:35Z")
I have a column in my data table type date, and I want to be able to query said column. When I try to press the magnifying glass "filter value" Kibana gives me an error. I guess what I am trying to ask is how do I create a date range filter for my data table? ---
**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [July 31, 2017, 10:20am UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/2 "2017-07-31T10:20:05Z")
Hi @Louie_Hernandez, could you let me know which version of Kibana you are using and what the error message is? A screenshot of the problem could be helpful too. Thank you! ---
**Author:** ![Louie\_Hernandez](https://avatars.discourse-cdn.com/v4/letter/l/f14d63/32.png) [@Louie\_Hernandez](https://discuss.elastic.co/u/Louie_Hernandez)\ **Post date:** [July 31, 2017, 2:24pm UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/3 "2017-07-31T14:24:42Z")
Hey! @weltenwort I am using Kibana version 5.4.1 It's not so much that I am getting an error message, but more so that i am trying to filter my data table with what's in my booked date or active date column. I am also wondering if there is a way to filter it with the timepicker on the top right of the screen. Or will I have to create a custom plugin to do that? ![Table2](https://us1.discourse-cdn.com/elastic/original/3X/0/d/0d61446f6f3d59ebf624fbe7a3bc0ee915608b66.PNG) ![setup2](https://us1.discourse-cdn.com/elastic/original/3X/9/a/9a6d1cf027e8a3bf2e0a9dda6a2fb17143b4a697.PNG) Regards, Lou ---
**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [July 31, 2017, 3:19pm UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/4 "2017-07-31T15:19:01Z")
The timepicker in the top left currently only filters by the primary time field configured for the index pattern. There are several other ways you could use to filter your results: - You can enter [range queries](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-query-string-query.html#_ranges) for any field into the query bar above the dashboard, e.g. `BookedDate:[2015-01-01 TO 2015-01-20]`. - You can click the 🔍 icons to the add filters for that specific date to the filter bar. You mentioned this does not work for you? - Starting with Kibana 5.5.0, there is a new filter editor interface, which allows you to define range filters on fields: ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/e/2ed8ae77d7ecb70a3672926f4cc495a1334bbea0.png) ---
**Author:** ![Louie\_Hernandez](https://avatars.discourse-cdn.com/v4/letter/l/f14d63/32.png) [@Louie\_Hernandez](https://discuss.elastic.co/u/Louie_Hernandez)\ **Post date:** [July 31, 2017, 3:57pm UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/5 "2017-07-31T15:57:16Z")
hey @weltenwort thanks for the response. Thanks your responses helped out a lot, I was not writing the range queries correctly. Also, just as an option, how do you configure a primary time field for an index pattern? ---
**Author:** ![weltenwort](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/weltenwort/32/53885_2.png) [@weltenwort](https://discuss.elastic.co/u/weltenwort)\ **Post date:** [August 1, 2017, 8:39am UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/6 "2017-08-01T08:39:13Z")
When creating an index pattern in the management section, you can select one of the date type fields as the primary time field: ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/d/bd3c56f2f3f6d6659f99cb3c490ba28aa500184a.png) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 29, 2017, 8:39am UTC](https://discuss.elastic.co/t/date-range-filter-in-data-table-kibana-5-4-1/95017/7 "2017-08-29T08:39:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.