# Date Format into ELK

**URL:** <https://discuss.elastic.co/t/date-format-into-elk/48728>\
**Category:** Elasticsearch\
**Created:** [April 28, 2016, 8:06pm UTC](https://discuss.elastic.co/t/date-format-into-elk/48728 "2016-04-28T20:06:17Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sarthak2016](https://avatars.discourse-cdn.com/v4/letter/s/d26b3c/32.png) [@sarthak2016](https://discuss.elastic.co/u/sarthak2016)\
**Post date:** [April 28, 2016, 8:06pm UTC](https://discuss.elastic.co/t/date-format-into-elk/48728/1 "2016-04-28T20:06:17Z")

</div>

Hello

I am facing alot of issues with Date time format.

Here is actual data into CSV file as below.  
04/13/2016 04:20:39  
04/13/2016 04:21:05

Elastic search template format for field as below to support date.  
"server\_timestamp": {  
"type": "date",  
"format": "MM/dd/yyyy HH:mm:ss"  
}

Logstash  
date {  
locale =\> "en"  
match =\> ["server\_timestamp" , "MM/dd/yyyy HH:mm:ss"]  
}

Kibana format looks as below,

\_source

Path:

Table format looks: server\_timestamp: April 12th 2016, 22:56:49.000  
JSON format looks: "server\_timestamp": "04/13/2016 04:56:49",

I am not sure why server\_timestamp into Table format and JSON format are different.

Data imported successfully and i can view it into kibana, but when i apply filter from Kibana visualization, i got below error.

Visualize: failed to parse date field [1460525820000] with format [MM/dd/yyyy HH:mm:ss]

Can you please let me know that which constant Datetime format i need apply,

Thanks for your help in advance,  
Sam

---

<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 5, 2017, 10:55pm UTC](https://discuss.elastic.co/t/date-format-into-elk/48728/2 "2017-07-05T22:55:24Z")

</div>