# Filebeat unable to parse date with timezone

**URL:** <https://discuss.elastic.co/t/filebeat-unable-to-parse-date-with-timezone/214498>\
**Category:** Beats\
**Tags:** filebeat\
**Created:** [January 9, 2020, 9:52pm UTC](https://discuss.elastic.co/t/filebeat-unable-to-parse-date-with-timezone/214498 "2020-01-09T21:52:07Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![harddaynight](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/harddaynight/32/60577_2.png) [@harddaynight](https://discuss.elastic.co/u/harddaynight)\
**Post date:** [January 9, 2020, 9:52pm UTC](https://discuss.elastic.co/t/filebeat-unable-to-parse-date-with-timezone/214498/1 "2020-01-09T21:52:08Z")

</div>

Hello Elastic Team,

Can you, please, help me to find out why my filebeat can't parse a date with timezone properly?

Sample of data:

```
{"date": "2020-01-07 05:00:00+03:00", some other JSON fields}

```

The message I get in logs:

```
 "reason":"failed to parse date field [2020-01-09 16:30:00+03:00] with format [yyyy-MM-dd HH:mm:ssZ]","caused_by":{"type":"date_time_parse_exception","reason":"Text '2020-01-09 16:30:00+03:00' could not be parsed at index 19"}}}

```

I have the following mapping for my index:

```
PUT /scrapper-000001
{
  "settings": {
  	"index": {
  		"number_of_shards": 3,
  		"number_of_replicas": 1
  	}
  },
	"aliases": {
  		"scrapper": {"is_write_index": true}
  	},
  "mappings": {
    "properties": {
      "date": {"type":"date", "format":"yyyy-MM-dd HH:mm:ssZ"}
    }
  }
}

```

Everything looks legit and works fine till I add a timezone.

---

<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, 9:52pm UTC](https://discuss.elastic.co/t/filebeat-unable-to-parse-date-with-timezone/214498/2 "2020-02-06T21:52:15Z")

</div>

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