# \[0\] "\_dateparsefailure"

**URL:** <https://discuss.elastic.co/t/0-dateparsefailure/266226>\
**Category:** Logstash\
**Created:** [March 4, 2021, 11:39am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226 "2021-03-04T11:39:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 4, 2021, 11:39am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/1 "2021-03-04T11:39:22Z")

</div>

I want to replace timestamp with my field timestamp. I have tried but getting error so kindly share solution for this problem.  
"message" =\> "8/12/2020 0:00,jack,jazz,your recent attemt failed.,"9000.00 have been Debited on 02-08-2020, 13:15:55. For assistance call 627-627.

```auto
input{

    file{

        path => "x:/x/kuchkar_.csv"

        start_position => "beginning"

        sincedb_path => "Null"

    }

}

filter{

    csv{

        separator => ","

        columns => ["Date","name","Telco","LoginStatus","withdraw"]

    }

    date{

        match =>["message", "M/dd/yyyy hh:mm"]

        target => "@timestamp"

        add_field => {"month" => "%{+M}"}

    }
    stdout{

        codec => rubydebug

    }

}

```

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [March 4, 2021, 1:27pm UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/2 "2021-03-04T13:27:21Z")

</div>

I'm not sure what you are trying to do for `month` so removed that for now. But try the below to see if it gives you what you are looking for.

This should read your Date column in your CSV and set `@timestamp` with that value.

```auto
input {
    file {
        path => "x:/x/kuchkar_.csv"
        start_position => "beginning"
        sincedb_path => "NUL"
    }
}
filter {
    csv {
        separator => ","
        columns => ["Date","name","Telco","LoginStatus","withdraw"]
    }

    date {
        match =>["Date", "M/dd/yyyy hh:mm"]
    }
}
output {
    stdout { codec => rubydebug }
}

```

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 5, 2021, 4:42am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/3 "2021-03-05T04:42:04Z")

</div>

sir Still I am getting same error \_dateparsefailure.

---

<div class="post-metadata">

**Author:** ![padamrai](https://avatars.discourse-cdn.com/v4/letter/p/3da27b/32.png) [@padamrai](https://discuss.elastic.co/u/padamrai)\
**Post date:** [March 5, 2021, 5:04am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/4 "2021-03-05T05:04:03Z")

</div>

@timestamp" =\> 2021-03-05T17:55:47.977Z,  
My date format =\> "Date" =\> "8/2/2020 0:00"  
How I can replace Date format with @timestamp format.

---

<div class="post-metadata">

**Author:** ![aaron-nimocks](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/aaron-nimocks/32/73965_2.png) [@aaron-nimocks](https://discuss.elastic.co/u/aaron-nimocks)\
**Post date:** [March 5, 2021, 11:38am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/5 "2021-03-05T11:38:09Z")

</div>

Try `match =>["Date", "M/dd/yyyy H:mm"]`

---

<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:** [April 2, 2021, 11:38am UTC](https://discuss.elastic.co/t/0-dateparsefailure/266226/6 "2021-04-02T11:38:41Z")

</div>

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