# Display date without time in Elasticsearch

**URL:** <https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266>\
**Category:** Kibana\
**Created:** [November 12, 2020, 10:57pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266 "2020-11-12T22:57:05Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![VeeT](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@VeeT](https://discuss.elastic.co/u/VeeT)\
**Post date:** [November 12, 2020, 10:57pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/1 "2020-11-12T22:57:05Z")

</div>

Hi,  
I have the following input in a "Date" field:  
Date=2020.11.12

Currently, it's displaying as this in Kibana:  
Date Nov 12, 2020 @ 00:00:00.000

I would like to display this as is in Kibana, i.e., Date: 2020.11.12. How do I do that? I want to use the yyyy.MM.dd format and without the timestamp. Can I modify the date field to do this?

This is what I have in the Index Template Mapping:  
"Date": {  
"format": "strict\_date\_optional\_time||epoch\_millis||yyyy.MM.dd",  
"index": true,  
"ignore\_malformed": false,  
"store": false,  
"type": "date",  
"doc\_values": true  
}

This is what I have in the logstash config file:  
input {  
udp { port =\> 1001 id =\> "syslog\_id" buffer\_size =\> 196608 receive\_buffer\_bytes =\> 196608 }  
}  
filter {  
if [message] =~ /InbTxnType/ {  
mutate { add\_tag =\> ["TRANSACTION", "SUMMARY"] }  
kv { trim\_key =\> " " trim\_value =\> " " source =\> "logMessage" value\_split =\> "=" field\_split =\> "," }  
date { match =\> ["Date","yyyy.MM.dd"] target =\> "Date" }  
}  
}

output {  
if "SUMMARY" in [tags] {  
elasticsearch{ hosts =\> ["elasticsearch-client:80"] index =\> "summary-transaction-%{+YYYY.MM}" }  
}  
}

Thanks!  
Vanessa

---

<div class="post-metadata">

**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\
**Post date:** [November 13, 2020, 2:34pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/2 "2020-11-13T14:34:12Z")

</div>

Hello @VeeT

Have you tried using a field formatter? [https://www.elastic.co/guide/en/kibana/current/managing-fields.html](https://www.elastic.co/guide/en/kibana/current/managing-fields.html)

Thanks,  
Matt

---

<div class="post-metadata">

**Author:** ![VeeT](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@VeeT](https://discuss.elastic.co/u/VeeT)\
**Post date:** [November 13, 2020, 3:50pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/3 "2020-11-13T15:50:58Z")

</div>

> [@mattkime](#):
>
> [https://www.elastic.co/guide/en/kibana/current/managing-fields.html](https://www.elastic.co/guide/en/kibana/current/managing-fields.html)

Hi Matt,  
Yes, I've done that. I've set the date format )yyyy.MM.dd) in the index pattern. Please see attached.

Thanks!  
Vee

 ![Date_index_pattern](https://us1.discourse-cdn.com/elastic/original/3X/e/e/ee22e81aa8cfe0926949105153ad2a0beef1b1c4.png)

---

<div class="post-metadata">

**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\
**Post date:** [November 14, 2020, 2:47am UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/4 "2020-11-14T02:47:15Z")

</div>

@VeeT

Which version of the stack are you using? Can you show a screenshot where the data isn't formatted as desired?

---

<div class="post-metadata">

**Author:** ![VeeT](https://avatars.discourse-cdn.com/v4/letter/v/f05b48/32.png) [@VeeT](https://discuss.elastic.co/u/VeeT)\
**Post date:** [November 16, 2020, 4:19pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/5 "2020-11-16T16:19:30Z")

</div>

Matt,  
We are using ELK 7.6.  
Here are the screenshots. The InputDate.png is the one that's being sent to us from the application thru Load Balancer to Logstash. The OutpuDate.png is the one that's being displayed in Kibana.

The desired result is "Date 2020.11.16".

Thanks!  
Vee

InputDate:  
 ![InputDate](https://us1.discourse-cdn.com/elastic/original/3X/b/9/b9b189b9fd461154d44df84248cbb651987c6acb.png)

OutputDate:  
 ![OutputDate](https://us1.discourse-cdn.com/elastic/original/3X/5/9/5941bb2929db083f5d653d7c08f067cd518ab0ec.png)

---

<div class="post-metadata">

**Author:** ![mattkime](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/mattkime/32/43522_2.png) [@mattkime](https://discuss.elastic.co/u/mattkime)\
**Post date:** [November 16, 2020, 4:33pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/6 "2020-11-16T16:33:46Z")

</div>

> Yes, I've done that. I've set the date format )yyyy.MM.dd) in the index pattern. Please see attached.

Thats not a screenshot from the index pattern field format editor. I suspect its an ingest related screenshot. Try going to `Stack Management` -\> `Index Patterns` and set the formatting there.

Thanks,  
Matt

---

<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 14, 2020, 4:33pm UTC](https://discuss.elastic.co/t/display-date-without-time-in-elasticsearch/255266/7 "2020-12-14T16:33:52Z")

</div>

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