# Query based on date field **URL:** \ **Category:** Kibana\ **Created:** [August 10, 2015, 1:14pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126 "2015-08-10T13:14:48Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![141984](https://avatars.discourse-cdn.com/v4/letter/1/c37758/32.png) [@141984](https://discuss.elastic.co/u/141984)\ **Post date:** [August 10, 2015, 1:14pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/1 "2015-08-10T13:14:48Z")
Hi, I have a filed called "date" of map "date": { "type": "date", "format": "dateOptionalTime" }, Examples values of this field are July 31st 2015, 12:39:50.569 July 31st 2015, 13:29:00.785 July 31st 2015, 15:45:00.105 How do I write a kibana query string to show all on the date July 31st 2015 ? ---
**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\ **Post date:** [August 11, 2015, 10:44am UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/2 "2015-08-11T10:44:17Z")
Why not just use the time picker? ---
**Author:** ![141984](https://avatars.discourse-cdn.com/v4/letter/1/c37758/32.png) [@141984](https://discuss.elastic.co/u/141984)\ **Post date:** [August 11, 2015, 11:01am UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/3 "2015-08-11T11:01:53Z")
I want to be able to specify a date range in the query string... ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [August 11, 2015, 11:54pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/4 "2015-08-11T23:54:29Z")
Which Kibana version are you using? In Kibana 4, date range is automatically part of the URL: [https://localhost:5601/#/visualize/create?type=pie&indexPattern=test2&\_g=(refreshInterval:(display:Off,pause:!f,section:0,value:0)](https://localhost:5601/#/visualize/create?type=pie&indexPattern=test2&_g=(refreshInterval:(display:Off,pause:!f,section:0,value:0)),**time:(from:'2015-08-10T07:00:00.000Z',mode:absolute,to:'2015-08-11T06:59:59.999Z'))**&\_a=(filters:!(),linked:!f,query:(query\_string:(analyze\_wildcard:!t,query:'\*')),vis:(aggs:!((id:'1',params:(),schema:metric,type:count)),listeners:(),params:(addLegend:!t,addTooltip:!t,isDonut:!f,shareYAxis:!t),type:pie)) ---
**Author:** ![141984](https://avatars.discourse-cdn.com/v4/letter/1/c37758/32.png) [@141984](https://discuss.elastic.co/u/141984)\ **Post date:** [August 12, 2015, 9:27am UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/5 "2015-08-12T09:27:34Z")
I am using Kibana4. Is is possible to specify a date range the Kibana query string, instead of the URL ? ---
**Author:** ![rcazorla](https://avatars.discourse-cdn.com/v4/letter/r/278dde/32.png) [@rcazorla](https://discuss.elastic.co/u/rcazorla)\ **Post date:** [August 12, 2015, 3:07pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/6 "2015-08-12T15:07:10Z")
You can use : date:[2015-04-02T12:50:31.491Z TO 2015-04-03T12:50:31.491Z] in the query toolbar (worked with Kibana 4.1.1) Pay caution to both end of your range, for example when you search for only 2015 Kibana will give you the 1st of january at 01:00:00.000, I don't know how it will react with a range EDIT : tried date:[2014 TO 2015], on a vertical bar chart, obtained the log from 31/12/2013 to 01/01/2015 (at 23:00:00.000 each with day interval), I recommand you tu use such chart to experiment with your interval first ---
**Author:** ![tbragin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tbragin/32/45166_2.png) [@tbragin](https://discuss.elastic.co/u/tbragin)\ **Post date:** [August 12, 2015, 4:29pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/7 "2015-08-12T16:29:25Z")
Ah, I thought you were talking about the URL query string, not the search bar. In the search bar, you can use the Lucene query syntax: [https://lucene.apache.org/core/2\_9\_4/queryparsersyntax.html](https://lucene.apache.org/core/2_9_4/queryparsersyntax.html) ---
**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, 2:14pm UTC](https://discuss.elastic.co/t/query-based-on-date-field/27126/8 "2017-07-06T14:14:56Z")