# Mutute Date in CSV

**URL:** <https://discuss.elastic.co/t/mutute-date-in-csv/39524>\
**Category:** Logstash\
**Created:** [January 19, 2016, 10:01am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524 "2016-01-19T10:01:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![sharan\_jain](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@sharan\_jain](https://discuss.elastic.co/u/sharan_jain)\
**Post date:** [January 19, 2016, 10:01am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/1 "2016-01-19T10:01:08Z")

</div>

Hi team ,

I have data in CSV File with some column as DATE .

Since Mutute Doesnot allow date .  
How can i set type DATE in Filter.

Thanks  
Sharan

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [January 19, 2016, 10:16am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/2 "2016-01-19T10:16:48Z")

</div>

Logstash deals with JSON documents and JSON doesn't have a date type (only string, number, bool, array, and object).

How fields are mapped in Elasticsearch is controlled via the index mappings, which are usually set via index templates.

---

<div class="post-metadata">

**Author:** ![sharan\_jain](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@sharan\_jain](https://discuss.elastic.co/u/sharan_jain)\
**Post date:** [January 19, 2016, 10:25am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/3 "2016-01-19T10:25:46Z")

</div>

I am Using Logstast to feed data into kibana .  
In which Fecha\_Creacion is my date column .  
by default while index creation it will take as String .  
So i need to set it DATE.

```
input {  
      file {
          path => "/data/TEST.csv"
          start_position => "beginning"
		  sincedb_path => "/dev/null"
      }
}

filter {  
    csv {
        columns => ["Descripcion", "Disenador", "Fecha_Creacion" , "ID"]
        separator => ","
    }
	mutate {
            convert => {"ID" =>"integer"}
    }

}

output {
    elasticsearch {
	index=>test
	}
    stdout {}
}

```

Any Suggestion ..how to achieve within .conf file only.

---

<div class="post-metadata">

**Author:** ![kaib](https://avatars.discourse-cdn.com/v4/letter/k/f14d63/32.png) [@kaib](https://discuss.elastic.co/u/kaib)\
**Post date:** [January 19, 2016, 11:39am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/4 "2016-01-19T11:39:35Z")

</div>

It is possible to match a date with the date filter, then it will be displayed as date in kibana.

> # Putting into @timestamp field
> 
> date{  
> match =\> ["dateFiled","yyyy-MM-dd HH:mm:ss Z","ISO8601"]  
> }
> 
> # Put into field of choice
> 
> date{  
> match =\> ["lastmodified","yyyy-MM-dd HH:mm:ss Z","ISO8601"]  
> target =\> "TargetField"  
> }

maybe this will help you

---

<div class="post-metadata">

**Author:** ![sharan\_jain](https://avatars.discourse-cdn.com/v4/letter/s/e495f1/32.png) [@sharan\_jain](https://discuss.elastic.co/u/sharan_jain)\
**Post date:** [January 19, 2016, 1:59pm UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/5 "2016-01-19T13:59:16Z")

</div>

> [@kaib](#):
>
> date{ match =\> ["lastmodified","yyyy-MM-dd HH:mm:ss Z","ISO8601"] target =\> "TargetField" }

Thanks Kaib , i am to load the data in kibana ..  
But there is one more format of date which throws warning  
data is 1/17/2016 22:35

Unable to parse this of date .

I have tried

date{  
match =\> ["F\_M","MM/dd/yyyy hh:mm:ss","ISO8601"]  
target =\> "F\_M"  
}

date{  
match =\> ["F\_M","MM/dd/yyyy hh:mm","ISO8601"]  
target =\> "F\_M"  
}

---

<div class="post-metadata">

**Author:** ![kaib](https://avatars.discourse-cdn.com/v4/letter/k/f14d63/32.png) [@kaib](https://discuss.elastic.co/u/kaib)\
**Post date:** [January 19, 2016, 3:05pm UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/6 "2016-01-19T15:05:17Z")

</div>

Infos on how to use the date filter: [Link](https://www.elastic.co/guide/en/logstash/current/plugins-filters-date.html)  
Infos for the Joda Time Patterns: [Link](http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html)

Just try around a litte, the later one looks closer to what you want. You dont need the ISO8601 ist just another pattern.

> match =\> ["F\_M","M/dd/yyyy hh:mm"]

this looks promising, cause ur date doesnt have a 01 at the start

---

<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 6, 2017, 5:15am UTC](https://discuss.elastic.co/t/mutute-date-in-csv/39524/7 "2017-07-06T05:15:13Z")

</div>