# Date Problem In kibana VIsualization

**URL:** <https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427>\
**Category:** Kibana\
**Created:** [September 13, 2019, 12:52pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427 "2019-09-13T12:52:20Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 13, 2019, 12:52pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/1 "2019-09-13T12:52:20Z")

</div>

I have converted date format into date and it changes into date format but when i try to visualize the date it does not show time only show date  
My record start on this date 2019-08-01 00:00:04, and end with this date 2019-08-31 23:58:59 i use to yyyy-MM-dd HH:mm:ss to convert and it converts into date format  
but when i use data table and shows data hourly wise it only shows date not time please help

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/c/2cf6493d9ecadac729f41133f8f1884eca96701e.png) please check the attached image i have selected date and it shows time with hourly base why it only shows date not tim please help

---

<div class="post-metadata">

**Author:** ![Marius\_Dragomir](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marius_dragomir/32/42087_2.png) [@Marius\_Dragomir](https://discuss.elastic.co/u/Marius_Dragomir)\
**Post date:** [September 13, 2019, 1:00pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/2 "2019-09-13T13:00:29Z")

</div>

Can you also post a screenshot of the field format for the `Date` field that you're using there?  
Also, what version of Kibana are you using?

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 13, 2019, 4:06pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/3 "2019-09-13T16:06:56Z")

</div>

i am using kibana 7.1.1

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/5/a/5a28c8839e316269f107eee9099014322851b42e.png)

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 14, 2019, 1:58pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/4 "2019-09-14T13:58:40Z")

</div>

any update?

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 18, 2019, 10:44am UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/5 "2019-09-18T10:44:33Z")

</div>

please help

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 18, 2019, 10:44am UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/6 "2019-09-18T10:44:52Z")

</div>

@Marius_Dragomir

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 18, 2019, 11:38am UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/7 "2019-09-18T11:38:35Z")

</div>

@Badger @admlko

---

<div class="post-metadata">

**Author:** ![Syed.Ubaid](https://avatars.discourse-cdn.com/v4/letter/s/df705f/32.png) [@Syed.Ubaid](https://discuss.elastic.co/u/Syed.Ubaid)\
**Post date:** [September 18, 2019, 1:02pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/8 "2019-09-18T13:02:48Z")

</div>

issue has been resolved i added scripted field for time and set format according to the requirements.

---

<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:** [October 16, 2019, 1:02pm UTC](https://discuss.elastic.co/t/date-problem-in-kibana-visualization/199427/9 "2019-10-16T13:02:49Z")

</div>

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