# Format timestamp Timelion into date

**URL:** <https://discuss.elastic.co/t/format-timestamp-timelion-into-date/184291>\
**Category:** Kibana\
**Tags:** timelion\
**Created:** [June 5, 2019, 7:18am UTC](https://discuss.elastic.co/t/format-timestamp-timelion-into-date/184291 "2019-06-05T07:18:59Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Eduardo\_De\_Zulueta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/eduardo_de_zulueta/32/47037_2.png) [@Eduardo\_De\_Zulueta](https://discuss.elastic.co/u/Eduardo_De_Zulueta)\
**Post date:** [June 5, 2019, 7:18am UTC](https://discuss.elastic.co/t/format-timestamp-timelion-into-date/184291/1 "2019-06-05T07:18:59Z")

</div>

Hi, Using the Timelion, I would like to know how to format the timefield ='time' \<- timestamp into days, something like this 'dd-mm-yyyy' in order to show the trend with big periods of time avoiding the split by hour.Thanks

---

<div class="post-metadata">

**Author:** ![markov00](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/markov00/32/33316_2.png) [@markov00](https://discuss.elastic.co/u/markov00)\
**Post date:** [June 27, 2019, 10:16am UTC](https://discuss.elastic.co/t/format-timestamp-timelion-into-date/184291/2 "2019-06-27T10:16:25Z")

</div>

Hi @Eduardo_De_Zulueta, I'm not completely sure I fully understand your request but I will try to give you some hints:

- have you tried to use the `Interval` dropdown just above the timelion expression? you can specify here that you want `1d` intervals so the data is aggregated in a daily basis
- if the problem is with the tooltip on the top-left side of the visualization, you can format the date displayed with the following function `.es(*).legend(timeFormat=DD-MM-YYYY)` following the format convention of moment.js [https://momentjs.com/docs/#/displaying/format/](https://momentjs.com/docs/#/displaying/format/)

If none of these are what you were looking, please could you specify a bit more your usecase and what you want to achieve? anything useful to understand better the request is welcome

Thanks

---

<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 25, 2019, 10:16am UTC](https://discuss.elastic.co/t/format-timestamp-timelion-into-date/184291/3 "2019-07-25T10:16:31Z")

</div>

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