# CSV/Time Bug

**URL:** <https://discuss.elastic.co/t/csv-time-bug/206845>\
**Category:** Logstash\
**Created:** [November 6, 2019, 6:01pm UTC](https://discuss.elastic.co/t/csv-time-bug/206845 "2019-11-06T18:01:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jim\_Thunder](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jim_thunder/32/45439_2.png) [@Jim\_Thunder](https://discuss.elastic.co/u/Jim_Thunder)\
**Post date:** [November 6, 2019, 6:01pm UTC](https://discuss.elastic.co/t/csv-time-bug/206845/1 "2019-11-06T18:01:11Z")

</div>

Hello!

I have files being sent in CSV format. My logstash config ONLY parses them into different fields. It does nothing else.

For some reason, whenever there is a date in the CSV file, the field that should contain that date has the wrong date. The field also looks like a timestamp; it has a time and a date instead of just "Month Day YYYY". The added timestamp for every single field with this issue is "18:00:00:000" That time never changes.

Any help would be awesome!

Thank you.

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [November 6, 2019, 7:19pm UTC](https://discuss.elastic.co/t/csv-time-bug/206845/2 "2019-11-06T19:19:57Z")

</div>

I would guess they are being indexed in elasticsearch with type date (possibly due to a template) and that your timezone is 6 hours behind UTC.

---

<div class="post-metadata">

**Author:** ![Jim\_Thunder](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jim_thunder/32/45439_2.png) [@Jim\_Thunder](https://discuss.elastic.co/u/Jim_Thunder)\
**Post date:** [November 6, 2019, 7:25pm UTC](https://discuss.elastic.co/t/csv-time-bug/206845/3 "2019-11-06T19:25:31Z")

</div>

Perfect, that answers my question. Thank you.

---

<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:** [December 4, 2019, 7:30pm UTC](https://discuss.elastic.co/t/csv-time-bug/206845/4 "2019-12-04T19:30:05Z")

</div>

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