# Formatting Date field

**URL:** <https://discuss.elastic.co/t/formatting-date-field/88580>\
**Category:** Kibana\
**Created:** [June 7, 2017, 12:22pm UTC](https://discuss.elastic.co/t/formatting-date-field/88580 "2017-06-07T12:22:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Varun\_Patel](https://avatars.discourse-cdn.com/v4/letter/v/57b2e6/32.png) [@Varun\_Patel](https://discuss.elastic.co/u/Varun_Patel)\
**Post date:** [June 7, 2017, 12:22pm UTC](https://discuss.elastic.co/t/formatting-date-field/88580/1 "2017-06-07T12:22:47Z")

</div>

I have date field which has default format.

I want to change format of that field to MMM-YYYY. How can I do so ?

---

<div class="post-metadata">

**Author:** ![erion](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@erion](https://discuss.elastic.co/u/erion)\
**Post date:** [June 7, 2017, 1:08pm UTC](https://discuss.elastic.co/t/formatting-date-field/88580/2 "2017-06-07T13:08:06Z")

</div>

You have to config the date format like your date string.  
Change the string format how would you like and match that in logstash.conf. I think is not possible change the config without change the date string.

---

<div class="post-metadata">

**Author:** ![Varun\_Patel](https://avatars.discourse-cdn.com/v4/letter/v/57b2e6/32.png) [@Varun\_Patel](https://discuss.elastic.co/u/Varun_Patel)\
**Post date:** [June 8, 2017, 5:08am UTC](https://discuss.elastic.co/t/formatting-date-field/88580/3 "2017-06-08T05:08:48Z")

</div>

is there any way to do it from Kibana ? If yes then can you please write the steps.

---

<div class="post-metadata">

**Author:** ![erion](https://avatars.discourse-cdn.com/v4/letter/e/779978/32.png) [@erion](https://discuss.elastic.co/u/erion)\
**Post date:** [June 8, 2017, 7:51am UTC](https://discuss.elastic.co/t/formatting-date-field/88580/4 "2017-06-08T07:51:04Z")

</div>

For that configuration you have to use logstash. The format date is decided by the string. For example if you have a log that timestamp is like [23/Mar/2017:09:45:15 +0100] you can configure that like  
date {  
match =\> ["timestamp", "dd/MMM/YYYY:HH:mm:ss Z"]  
target =\> "@timestamp"  
}.  
So if you want to modify that the first step is modify data passed in ES and config it in Logstash.

---

<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, 7:51am UTC](https://discuss.elastic.co/t/formatting-date-field/88580/5 "2017-07-06T07:51:09Z")

</div>

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