# Date fields are not working **URL:** \ **Category:** Kibana\ **Created:** [December 19, 2018, 11:16am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497 "2018-12-19T11:16:32Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\ **Post date:** [December 19, 2018, 11:16am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/1 "2018-12-19T11:16:32Z")
Hello everyone, As I am trying to populate area chart with my date fields. It is not working in kibana, when i check with elasticsearch query its working there. ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/4/64c2d189ab69b50c1f28ab0638d8f2dd27f87b9c.png) My elasticsearch query : ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/7/a711e707ca76a739aa71f1319f5a34de1b2b628f.png) which is showing results in kibana console. Below is my mapping: PUT test1 { "settings": { "index.mapping.ignore\_malformed": true }, "mappings": { "each\_file": { "properties": { "Size": {"type": "integer","ignore\_malformed": false }, "Path ID": {"type": "integer","ignore\_malformed": false }, "Family Item Number": {"type": "integer","ignore\_malformed": false }, "Creation Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"}, "Document Creation Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"}, "Document Modification Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"}, "Email Received Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"}, "Email Sent Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"}, "Modification Time": {"type": "date", "format": "E dd MMM yyyy HH:mm:ss a z"} } } } } and my date format : Document Creation Time : Fri 02 Nov 2001 06:28:37 AM IST I dont know how to show chart in kibana? Thanks for help. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [December 20, 2018, 9:15am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/3 "2018-12-20T09:15:09Z")
Probably that pesky time filter. [Top right of Kibana screen.](https://www.elastic.co/guide/en/kibana/current/set-time-filter.html) ---
**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\ **Post date:** [December 20, 2018, 10:55am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/4 "2018-12-20T10:55:31Z")
Can you be more specific. my date filter is not applying anywhere in whole kibana. Is their any problem with my mapping or date format. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [December 20, 2018, 10:58am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/5 "2018-12-20T10:58:58Z")
> [@Nusrath](#): > > Can you be more specific. Does your Kibana index pattern have a choice of date field associated with the time picker? ---
**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\ **Post date:** [December 20, 2018, 11:10am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/6 "2018-12-20T11:10:09Z")
No, i have only date field without time picker and its work good with numbers and strings fields ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/d/5dbc9d188a7a15cdb637a7bea73ab34cafb7f5d2.png) when i add time filter field it show no results match ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/4/2441903fda86352f1f3746718b5cec8ca48cb15e.png) ![image](https://us1.discourse-cdn.com/elastic/original/3X/b/d/bd7ddb3199e5d7d95242f48017bd0d77844ab303.png) ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 20, 2018, 11:16am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/7 "2018-12-20T11:16:23Z")
It would help if you could show a full screenshot so we can see the time-picker in the upper right corner and verify that this is set so it covers the `Creation Time` of the documents, which seems to be in 2009 based on the sample you showed. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [December 20, 2018, 11:17am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/8 "2018-12-20T11:17:39Z")
> [@Nusrath](#): > > when i add time filter field it show no results match I'm not sure what's going on here. If your elasticsearch query is working correctly this is probably the wrong forum and you need to move the discussion over to the Kibana forums to figure out what's up with that visualization, ---
**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\ **Post date:** [December 20, 2018, 11:20am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/9 "2018-12-20T11:20:47Z")
![image](https://us1.discourse-cdn.com/elastic/original/3X/4/6/4629e28cfc80f4e169720e80bb6ac72b1ce67aed.png) ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 20, 2018, 11:23am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/10 "2018-12-20T11:23:35Z")
That looks correct, so I would agree with Mark that moving the discussion to the Kibana forum is a good idea. ---
**Author:** ![Mark\_Harwood](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mark_harwood/32/10538_2.png) [@Mark\_Harwood](https://discuss.elastic.co/u/Mark_Harwood)\ **Post date:** [December 20, 2018, 11:27am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/11 "2018-12-20T11:27:48Z")
Moved to Kibana forum ---
**Author:** ![Nusrath](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Nusrath](https://discuss.elastic.co/u/Nusrath)\ **Post date:** [December 20, 2018, 11:28am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/12 "2018-12-20T11:28:42Z")
Thanks you Mark 🙂 ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 17, 2019, 11:28am UTC](https://discuss.elastic.co/t/date-fields-are-not-working/161497/13 "2019-01-17T11:28:44Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.