# java.lang.IllegalArgumentException: Invalid format - date problem

**URL:** <https://discuss.elastic.co/t/java-lang-illegalargumentexception-invalid-format-date-problem/110833>\
**Category:** Elasticsearch\
**Created:** [December 8, 2017, 11:26am UTC](https://discuss.elastic.co/t/java-lang-illegalargumentexception-invalid-format-date-problem/110833 "2017-12-08T11:26:42Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![rromanovic](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@rromanovic](https://discuss.elastic.co/u/rromanovic)\
**Post date:** [December 8, 2017, 11:26am UTC](https://discuss.elastic.co/t/java-lang-illegalargumentexception-invalid-format-date-problem/110833/1 "2017-12-08T11:26:42Z")

</div>

Hi,  
I'm having problems with storing date in "yyyy-MM-dd HH:mm:ss,SSS" format in index.

The format I'm reading from log file is "yyyy-MM-dd HH:mm:ss.SSSS", for example "2017-10-31 05:00:00.4216".

First, I'm creating field in which I store date in format "yyyy-MM-dd HH:mm:ss.SSS". After that I'm using gsub filter to change "." to "," in date to get format "yyyy-MM-dd HH:mm:ss,SSS", and lastly I'm using date filter to store field as a date.

Here is the logstash conf:  
input {  
beats {  
port =\> "5043"  
}  
}

filter {  
grok {  
match =\> {"message" =\> "(?\<datumGNBR\>(\d{4}(-\d{2}){2} \d{2}:\d{2}:\d{2}.\d{3}))\d"}  
}

```
mutate {
  gsub => ["datumGNBR", "\.", ","]
}

date {
  match => ["datumGNBR", "yyyy-MM-dd HH:mm:ss,SSS"]
}

```

}

output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "someindex"  
}  
}

datumGNBR is defined as follows in elasticsearch:  
"datumGNBR": {  
"type": "date",  
"format": ["yyyy-MM-dd HH:mm:ss,SSS"]  
}

And after starting logstash and filebeat I can't get my someindex populated. There are no errors in filebeat nor logstash logs, but in elasticsearch log I'm finding errors like this:

org.elasticsearch.index.mapper.MapperParsingException: failed to parse [datumGNBR]  
...  
Caused by: java.lang.IllegalArgumentException: Invalid format: "2017-10-31 23:00:46,519"

Does anybody have any idea where I'm wrong?  
Thank you!

---

<div class="post-metadata">

**Author:** ![rromanovic](https://avatars.discourse-cdn.com/v4/letter/r/fbc32d/32.png) [@rromanovic](https://discuss.elastic.co/u/rromanovic)\
**Post date:** [December 12, 2017, 4:07pm UTC](https://discuss.elastic.co/t/java-lang-illegalargumentexception-invalid-format-date-problem/110833/2 "2017-12-12T16:07:09Z")

</div>

Once I defined datumGNBR as follows:

```
"datumGNBR": {
  "type": "date",
  "format": "yyyy-MM-dd HH:mm:ss.SSS||yyyy-MM-dd'T'HH:mm:ss.SSSZ"
}

```

everything sorted out.

Link I found very useful: [https://github.com/elastic/kibana/issues/66](https://github.com/elastic/kibana/issues/66)

---

<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:** [January 9, 2018, 4:07pm UTC](https://discuss.elastic.co/t/java-lang-illegalargumentexception-invalid-format-date-problem/110833/3 "2018-01-09T16:07:13Z")

</div>

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