# Change Date format in kibana

**URL:** https://discuss.elastic.co/t/change-date-format-in-kibana/185764
**Category:** Kibana
**Created:** [June 14, 2019, 5:50am UTC](https://discuss.elastic.co/t/change-date-format-in-kibana/185764 "2019-06-14T05:50:58Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![A\_google\_user](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_google_user/32/46709_2.png) [@A\_google\_user](https://discuss.elastic.co/u/A_google_user)
#### Post date: [June 14, 2019, 5:50am UTC](https://discuss.elastic.co/t/change-date-format-in-kibana/185764/1 "2019-06-14T05:50:58Z")

</div>

I have data in which date format is in epoch format(milli second). Now I want to filter data on that field. How can I make this possible ?  
Is there any feature or mapping or plug in, by which data gets stored in date format(yyyy-mm-dd)?

---

<div class="post-metadata">

### Author: ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)
#### Post date: [June 21, 2019, 1:20pm UTC](https://discuss.elastic.co/t/change-date-format-in-kibana/185764/2 "2019-06-21T13:20:00Z")

</div>

All dates are stored in Elasticsearch as longs. "Internally, dates are converted to UTC (if the time-zone is specified) and stored as a long number representing milliseconds-since-the-epoch" [https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html](https://www.elastic.co/guide/en/elasticsearch/reference/current/date.html)

You can query dates with range queries using date math strings [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#ranges-on-dates](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#ranges-on-dates) or date formatted strings [https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#\_date\_format\_in\_range\_queries](https://www.elastic.co/guide/en/elasticsearch/reference/current/query-dsl-range-query.html#_date_format_in_range_queries)

---

<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 19, 2019, 1:20pm UTC](https://discuss.elastic.co/t/change-date-format-in-kibana/185764/3 "2019-07-19T13:20:02Z")

</div>

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