# Using custom date format on elasticsearch and Kibana4

**URL:** <https://discuss.elastic.co/t/using-custom-date-format-on-elasticsearch-and-kibana4/22504>\
**Category:** Elasticsearch\
**Created:** [March 4, 2015, 12:05am UTC](https://discuss.elastic.co/t/using-custom-date-format-on-elasticsearch-and-kibana4/22504 "2015-03-04T00:05:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ayman](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Ayman](https://discuss.elastic.co/u/Ayman)\
**Post date:** [March 4, 2015, 12:05am UTC](https://discuss.elastic.co/t/using-custom-date-format-on-elasticsearch-and-kibana4/22504/1 "2015-03-04T00:05:54Z")

</div>

Hi,

I have nginx logs and i have this date format [02/Mar/2015:13:02:51 +0000]

What should i use in elasticsearch and what i should put in the dateformat  
field of Kibana4?

curl -XGET '[http://localhost:9200/\_mapping?pretty](http://localhost:9200/_mapping?pretty)'  
{  
"nginx" : {  
"mappings" : {  
"t07\_nginx" : {  
"properties" : {  
"@timestamp [https://github.com/timestamp](https://github.com/timestamp)" : {  
"type" : "date",  
"format" : "dateOptionalTime"  
},  
"body\_bytes\_sent" : {  
"type" : "string"  
},  
"geoip\_country\_code" : {  
"type" : "string"  
},  
"host" : {  
"type" : "string"  
},  
"http\_host" : {  
"type" : "string"  
},  
"http\_referer" : {  
"type" : "string"  
},  
"http\_user\_agent" : {  
"type" : "string",  
"index" : "not\_analyzed"  
},  
"http\_x\_forwarded\_for" : {  
"type" : "string"  
},  
"message" : {  
"type" : "string"  
},  
"msec request\_time" : {  
"type" : "string"  
},  
"remote\_addr" : {  
"type" : "string"  
},  
"request\_http\_protocol" : {  
"type" : "string"  
},  
"request\_time" : {  
"type" : "string"  
},  
"request\_type" : {  
"type" : "string"  
},  
"request\_url" : {  
"type" : "string"  
},  
"status" : {  
"type" : "string"  
},  
"upstream\_addr" : {  
"type" : "string"  
},  
"upstream\_response\_time" : {  
"type" : "string"  
}  
}  
}  
}  
}

with the above i can't see any data(events) in Kibana

Thanks

--  
You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/2dae7640-14dd-4e23-8621-2fc1d5d12cc7%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/2dae7640-14dd-4e23-8621-2fc1d5d12cc7%40googlegroups.com).  
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).

---

<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, 12:28am UTC](https://discuss.elastic.co/t/using-custom-date-format-on-elasticsearch-and-kibana4/22504/2 "2017-07-06T00:28:46Z")

</div>