# I want to convert my date format yyyymmdd into month name date and year like mmm dd yyy (Apr 30 2012)

**URL:** <https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394>\
**Category:** Logstash\
**Created:** [November 14, 2020, 8:38am UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394 "2020-11-14T08:38:46Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 8:38am UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/1 "2020-11-14T08:38:46Z")

</div>

Hi

I am having a log like the below

\<#\> 20200924 15:14:40.918 280018000 EV.INF [MVINB-LSL2.T1G1\_ATMTH\_SL main.main TSP1.T1G1\_ATMTH\_SL] Process T1G1\_ATMTH\_SL starting in progress...

in the above log , i want to convert my date (20200924) to string Sep 24 2020 in the kibana. Is there any way please help me on this.

Thanks and Regards,  
M.Lokesh

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [November 14, 2020, 1:54pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/2 "2020-11-14T13:54:29Z")

</div>

I assume you would have a date field in your elasticsearch. Some ways to covert your date .

1. You can parse your log to convert date to "Sep 24 2020" format before sending to Elasticsearch.
2. Keep your date field format as "20200924" and convert it when showing in Kibana using [painless script](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html).

---

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 2:07pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/3 "2020-11-14T14:07:25Z")

</div>

Hi @wangqinghuan Thank you for your reply.

Can i know what is the script to convert this date format "20200924" to "Sep 24 2020" . Can i make these script in the scripted field of kibana.

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [November 14, 2020, 2:45pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/4 "2020-11-14T14:45:12Z")

</div>

Convert date before index need you make some change code when you indexing document, such as following Java code:  
Date rawDate = new SimpleDateFormat('yyyymmdd).parse('20200924');  
String newDate = new SimpleDateFormat('Mon dd yyyy).format(rawDate);  
Convert date when quering need you make some painless script, which is a language similar to Java. Although Kibana provides [interface](https://www.elastic.co/guide/en/kibana/current/scripted-fields.html) to help you create scripted fields.

---

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 2:53pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/5 "2020-11-14T14:53:15Z")

</div>

@wangqinghuan Can write like this in logstash.conf. here i am giving a file consisting of a list of logs that i litsed above as the input

input{

```
stdin {

 }

```

}

filter {

grok{

match=\>{

"message"=\> "%{INT:log\_date}\s\*%{TIME:time}\s\*\s\*%{INT:event\_id}\s\*\s\*%{GREEDYDATA:event\_type}\s\*\s\*[\s\*\s\*%{HOSTNAME:host\_name}.%{USERNAME:Process\_name}\s%{HOSTNAME:thread}\s\*\s\*\s\*\s\*\s\*\s\*%{USERNAME:logger\_name}\s\*\s\*\s\*\s\*\s\*]\s\*\s\*%{GREEDYDATA:message}"

}

}

Date rawDate = new SimpleDateFormat('yyyymmdd).parse('log\_date');

String newDate = new SimpleDateFormat('Mon dd yyyy).format(rawDate);

}

output {

elasticsearch {

```
  hosts => ["127.0.0.1:9200"]

  index => "sattestingdatedate"

```

}

}

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [November 14, 2020, 3:37pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/6 "2020-11-14T15:37:29Z")

</div>

When using Logstash, you could only use [ruby filter](https://www.elastic.co/guide/en/logstash/current/plugins-filters-ruby.html) to change your date format.

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [November 14, 2020, 3:45pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/7 "2020-11-14T15:45:19Z")

</div>

```
filter{
ruby{
init => 'require "time"'
code => "event.set('log_date',Date.strptime(log_date, '%Y%m%d').strftime('%b %d %Y'))"
}
}
```

---

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 4:47pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/8 "2020-11-14T16:47:08Z")

</div>

@wangqinghuan i am getting this error

[2020-11-14T22:16:08,990][ERROR][logstash.filters.ruby][main][a81999a732f4939fea3b072754eb61bc46abe723ddf4bf4bfa4435a07b09da48] Ruby exception occurred: undefined local variable or method `log\_date' for #LogStash::Filters::Ruby:0x420cd67

---

<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:** [November 14, 2020, 4:51pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/9 "2020-11-14T16:51:42Z")

</div>

> [@wangqinghuan](#):
>
> `code => "event.set('log_date',Date.strptime(log_date, '%Y%m%d').strftime('%b %d %Y'))"`

Try

```
code => "event.set('log_date',Date.strptime(event.get(log_date), '%Y%m%d').strftime('%b %d %Y'))"

```

---

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 5:04pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/10 "2020-11-14T17:04:48Z")

</div>

@wangqinghuan i tried but still getting same error

[2020-11-14T22:33:00,647][ERROR][logstash.filters.ruby][main][f60c6fd2ea6c1769405562d564f475d434cff8f60d85d2571597332021f0d998] Ruby exception occurred: undefined local variable or method `log\_date' for #LogStash::Filters::Ruby:0x5e61d649

---

<div class="post-metadata">

**Author:** ![wangqinghuan](https://avatars.discourse-cdn.com/v4/letter/w/d26b3c/32.png) [@wangqinghuan](https://discuss.elastic.co/u/wangqinghuan)\
**Post date:** [November 14, 2020, 5:12pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/11 "2020-11-14T17:12:55Z")

</div>

Hi,  
This is pseudocode . You should make some change combine your exsiting data.

---

<div class="post-metadata">

**Author:** ![Lokesh\_Mayan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lokesh_mayan/32/78641_2.png) [@Lokesh\_Mayan](https://discuss.elastic.co/u/Lokesh_Mayan)\
**Post date:** [November 14, 2020, 5:19pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/12 "2020-11-14T17:19:26Z")

</div>

Ok. Got It . Thank you so much @wangqinghuan 🥰

---

<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:** [December 12, 2020, 5:19pm UTC](https://discuss.elastic.co/t/i-want-to-convert-my-date-format-yyyymmdd-into-month-name-date-and-year-like-mmm-dd-yyy-apr-30-2012/255394/13 "2020-12-12T17:19:37Z")

</div>

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