# \_dateparsefailure csv date time YYYY-MM-dd HH:mm:ss

**URL:** <https://discuss.elastic.co/t/dateparsefailure-csv-date-time-yyyy-mm-dd-hhss/237725>\
**Category:** Logstash\
**Created:** [June 19, 2020, 3:53am UTC](https://discuss.elastic.co/t/dateparsefailure-csv-date-time-yyyy-mm-dd-hhss/237725 "2020-06-19T03:53:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gonzapata](https://avatars.discourse-cdn.com/v4/letter/g/3be4f8/32.png) [@gonzapata](https://discuss.elastic.co/u/gonzapata)\
**Post date:** [June 19, 2020, 3:53am UTC](https://discuss.elastic.co/t/dateparsefailure-csv-date-time-yyyy-mm-dd-hhss/237725/1 "2020-06-19T03:53:55Z")

</div>

Hi,

I manage to parse message field from a csv to several fields from filebeat to logstash, I want to match a date format (like 2020-06-18 22:36:21) but when I use date and match filter it give me \_dateparsefailure I tried with grok and it show \_grokparsefailure".

The message from filebeat is:

`"message" => "\"2020-06-18 23:34:51\",\"2020-06-18 23:34:51\",\"2020-06-18 23:35:24\",...more fields.`

I parse and I have the 3 first fields in start, answer and end fields:

ej:  
`"start" => "2020-06-18 23:34:51" `  
I want this field to be the timestamp.

grok pattern use and date plugin usage is like this:

```auto
   grok {
      match => {
        "start" => "YYYY-MM-dd HH:mm:ss"
      }
    }

    date {
      match => ["start", '"YYYY-MM-dd HH:mm:ss"']
      timezone => "%{[logstash][timezone]}"
      target => "@timestamp"
    }

```

Any help will be apreciated.

---

<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 17, 2020, 3:53am UTC](https://discuss.elastic.co/t/dateparsefailure-csv-date-time-yyyy-mm-dd-hhss/237725/2 "2020-07-17T03:53:59Z")

</div>

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