# Date format, how to change it?

**URL:** <https://discuss.elastic.co/t/date-format-how-to-change-it/219259>\
**Category:** Logstash\
**Created:** [February 13, 2020, 5:08pm UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259 "2020-02-13T17:08:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mbt\_Mbt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mbt_mbt/32/56310_2.png) [@Mbt\_Mbt](https://discuss.elastic.co/u/Mbt_Mbt)\
**Post date:** [February 13, 2020, 5:08pm UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259/1 "2020-02-13T17:08:50Z")

</div>

Hello good afternoon,

I am trying to change the way of displaying date type data but I am not able.

Can someone help me on how to visualize the dates with the format: 2020-13-02T10:01:01.000Z

Currently the field has the format, charged: Feb 13, 2020 @ 17:54:24.870

My filter looks that:

date { match =\> ["charged", "yyyy-MM-dd HH:mm:ss", "ISO8601"]  
timezone =\> "Etc/GMT+1"  
target =\> "charged"  
}

Many thanks

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 13, 2020, 5:28pm UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259/2 "2020-02-13T17:28:07Z")

</div>

> [@Mbt\_Mbt](#):
>
> date { match =\> ["charged", "yyyy-MM-dd HH:mm:ss", "ISO8601"]

The format in the date filter has to match the format of the field. Try

```
date { match => ["charged", "MMM dd, yyyy '@' HH:mm:ss.SSS"] }

```

---

<div class="post-metadata">

**Author:** ![Mbt\_Mbt](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mbt_mbt/32/56310_2.png) [@Mbt\_Mbt](https://discuss.elastic.co/u/Mbt_Mbt)\
**Post date:** [February 14, 2020, 9:26am UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259/3 "2020-02-14T09:26:34Z")

</div>

Thanks for your help,

it didnt worked,

The initial format is string with the following form

execEndTime:

2020-02-14 08:19:45.060

After applying the pugling date, we transform the data to date type

date { match =\> ["execEndTime", "yyyy-MM-dd HH:mm:ss", "ISO8601"]  
timezone =\> "Etc/GMT+1"  
target =\> "execEndTime"  
}

The result obtained in Kibana is:

execEndTime:

Feb 14, 2020 @ 09:19:45.060

I need to visulize with the format:

2020-14-02T09:19:45.060Z

Is there any way to have that information with the latest format?

Many thanks

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [February 14, 2020, 4:45pm UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259/4 "2020-02-14T16:45:38Z")

</div>

You want to change the format that the presentation layer uses? Or you want to parse the date?

---

<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:** [March 13, 2020, 4:45pm UTC](https://discuss.elastic.co/t/date-format-how-to-change-it/219259/5 "2020-03-13T16:45:59Z")

</div>

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