# CSV Export from a lens - No date is shown in the CSV document

**URL:** <https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192>\
**Category:** Kibana\
**Tags:** lens, visualisation\
**Created:** [November 1, 2023, 10:55am UTC](https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192 "2023-11-01T10:55:10Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![deepack86](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@deepack86](https://discuss.elastic.co/u/deepack86)\
**Post date:** [November 1, 2023, 10:55am UTC](https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192/1 "2023-11-01T10:55:10Z")

</div>

Hi!

I have some problem with the CSV export from a lends trend.  
If i choose the Minimum Interval under 1 hour, in my export is only shown  
the time and not the Date + time.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/a/c/ac2a60f716c19c4e34f69ab22c6be2624cc1b690.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/9/f/9fba749d3b0335f2bb42b2a19b5c7312104a9e5d.png)

If the Minimun Intervall is above one hour, the date and time will shown.  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/8/28779f61e43429d847aa3d338205d86131d58766.png)  
 ![image](https://us1.discourse-cdn.com/elastic/original/3X/1/9/19a672d7e21073e14eeb9904bd45e5341f5db0fb.png)

Is there a possibility to chance it, that the date and time is shown with an intervall from 5 minutes?

We use Elastic 8.6.1

Greetz Thomas

---

<div class="post-metadata">

**Author:** ![Marco\_Liberati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/marco_liberati/32/82953_2.png) [@Marco\_Liberati](https://discuss.elastic.co/u/Marco_Liberati)\
**Post date:** [November 1, 2023, 12:22pm UTC](https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192/2 "2023-11-01T12:22:11Z")

</div>

There's already an issue for this [here](https://github.com/elastic/kibana/issues/93747) which got incorporated into this other feature request: [[Lens] Contextual formatting · Issue #93265 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/93265)

---

<div class="post-metadata">

**Author:** ![deepack86](https://avatars.discourse-cdn.com/v4/letter/d/9de0a6/32.png) [@deepack86](https://discuss.elastic.co/u/deepack86)\
**Post date:** [November 2, 2023, 9:36am UTC](https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192/3 "2023-11-02T09:36:39Z")

</div>

thanks! Now it works. The solution is to change the date or rather to extend it with year and month

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/2/8/28d5e4ce0a6a6f2c1e557186a5ab0b0a0de6fdb3.png)

---

<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:** [November 30, 2023, 9:37am UTC](https://discuss.elastic.co/t/csv-export-from-a-lens-no-date-is-shown-in-the-csv-document/346192/4 "2023-11-30T09:37:20Z")

</div>

Closed on November 30, 2023, 9:37am UTC

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