# Using my own date field instead of using the default timestamp in index creation

**URL:** <https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479>\
**Category:** Logstash\
**Created:** [January 9, 2020, 6:59pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479 "2020-01-09T18:59:20Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kumar4](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar4/32/48326_2.png) [@kumar4](https://discuss.elastic.co/u/kumar4)\
**Post date:** [January 9, 2020, 6:59pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/1 "2020-01-09T18:59:20Z")

</div>

hello, i want to use the date in column named time in my csv file instead of timestamp when creating index,i indexed a csv file containing multiple columns, among the columns there is a date field in Y-m-d H:M:S format, when i try to use logstash -f it give me \_dateparsefaillure, an example of csv date column is: 2019-12-31 15:22:12, the problem is that i cant use that field instead of timpstamp in order to generate graphical charts and always in kibana the type of the field is sting not date , in logstash i use

date {  
match =\> ["time", "yyyy-MM-dd HH:mm:ss"]  
target =\> @timestamp  
}  
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:** [January 9, 2020, 8:46pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/2 "2020-01-09T20:46:33Z")

</div>

Can you show us the value of the field you want to parse in kibana, copied from the JSON tab on an expanded event in Discover?

---

<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:** [January 9, 2020, 10:23pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/4 "2020-01-09T22:23:09Z")

</div>

Field names are case sensitive. [time] and [Time] are different fields.

---

<div class="post-metadata">

**Author:** ![kumar4](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kumar4/32/48326_2.png) [@kumar4](https://discuss.elastic.co/u/kumar4)\
**Post date:** [January 9, 2020, 10:27pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/6 "2020-01-09T22:27:57Z")

</div>

i use the same name in my conf and in csv just in comment i wrote it with 'T' i checked it s the same name

---

<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:** [January 9, 2020, 11:51pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/7 "2020-01-09T23:51:27Z")

</div>

Please show your logstash configuration.

---

<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:** [February 6, 2020, 11:51pm UTC](https://discuss.elastic.co/t/using-my-own-date-field-instead-of-using-the-default-timestamp-in-index-creation/214479/8 "2020-02-06T23:51:35Z")

</div>

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