# Kibana map date format **URL:** \ **Category:** Kibana\ **Tags:** maps\ **Created:** [June 18, 2021, 10:07am UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369 "2021-06-18T10:07:43Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![jvidin](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jvidin](https://discuss.elastic.co/u/jvidin)\ **Post date:** [June 18, 2021, 10:07am UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/1 "2021-06-18T10:07:43Z")
Hi There , Im ingesting some 'date type' data using the following mapping properties. ```auto "processed_date": { "type": "date", "format": "yyyy/MM/dd HH:mm:ss.SSSZZ||yyyy/MM/dd HH:mm:ss.SSS||yyyy/MM/dd" }, ``` When looking at the json DEV response i see it correctly represented ```auto "processed_date" : "2019/11/20 00:00:00.000", ``` it shows something like this : processed\_date 1589241600000 ![image](https://us1.discourse-cdn.com/elastic/original/3X/e/3/e312b962365f329419226a87a6cd053d4563124f.jpeg) v 7.11.1 Thank you Jorge Vidinha ---
**Author:** ![jsanz](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jsanz/32/53734_2.png) [@jsanz](https://discuss.elastic.co/u/jsanz)\ **Post date:** [June 18, 2021, 1:46pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/2 "2021-06-18T13:46:55Z")
Tested in 7.13 (I can try later in 7.11) the following steps 1. Create some sample data with your formatter, etc ```auto PUT test_date { "mappings": { "dynamic": false, "properties": { "location": { "type": "geo_point" }, "processed_date": { "type": "date", "format": "yyyy/MM/dd HH:mm:ss.SSSZZ||yyyy/MM/dd HH:mm:ss.SSS||yyyy/MM/dd" } } } } POST test_date/_doc { "location": [-71.34, 41.12] , "processed_date": "2019/11/20 00:00:00.000" } POST test_date/_doc { "location": [-70, 42] , "processed_date": "2020/01/20 12:00:00.000" } POST test_date/_doc { "location": [-75, 32] , "processed_date": "2020/01/27" } ``` 1. Created the index pattern 2. Created a new map with the data layer and everything seems fine ![image](https://us1.discourse-cdn.com/elastic/original/3X/3/c/3cf37fab68b7d3722e3295ed1405d29e5bbb561f.png) Have you tried Kibana field formatter in the index pattern? You can format the date the way you want it represented, for example: ![image](https://us1.discourse-cdn.com/elastic/original/3X/4/4/44de30ee8234a2d9b29dcfde2f1d24d8126d8c64.png) ... and Maps will honor that setting ![image](https://us1.discourse-cdn.com/elastic/original/3X/f/e/fede93d25902c646fbadef353b4127e67528f178.png) Hope it helps! ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [June 20, 2021, 12:53pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/3 "2021-06-20T12:53:17Z")
This is a regression in 7.11, [[Maps] Tooltips with timestamp appear as epoch · Issue #95072 · elastic/kibana · GitHub](https://github.com/elastic/kibana/issues/95072), that has been resolved in 7.12 and higher versions, [[Maps] fix tooltips with timestamp appear as epoch by nreese · Pull Request #95106 · elastic/kibana · GitHub](https://github.com/elastic/kibana/pull/95106). You will need to upgrade to resolve the issue. ---
**Author:** ![jvidin](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jvidin](https://discuss.elastic.co/u/jvidin)\ **Post date:** [June 21, 2021, 11:43am UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/4 "2021-06-21T11:43:54Z")
Thanks @jsanz , i was not aware of field formater , i tryed to make use of it but also did not work .. now we know why after @Nathan_Reese explanation ... Thanks anyway for you time. Regards ---
**Author:** ![jvidin](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jvidin](https://discuss.elastic.co/u/jvidin)\ **Post date:** [June 21, 2021, 11:45am UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/5 "2021-06-21T11:45:28Z")
Thanks @Nathan_Reese , any great blog or advise on version upgrades . Regards ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [June 21, 2021, 1:05pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/6 "2021-06-21T13:05:23Z")
> **[Upgrade Kibana | Kibana Guide \[7.13\] | Elastic](https://www.elastic.co/guide/en/kibana/current/upgrade.html)** ---
**Author:** ![jvidin](https://avatars.discourse-cdn.com/v4/letter/j/da6949/32.png) [@jvidin](https://discuss.elastic.co/u/jvidin)\ **Post date:** [June 21, 2021, 1:31pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/7 "2021-06-21T13:31:04Z")
Thanks @Nathan_Reese , Does that mean upgrading Kibana only to 7.13 would be sufficient ? and staying with the elastic nodes at 7.11 ... Since i plan to go with elastic cloud soon or later it would make things simpler for this on prem deployment im working at the moment ... thanks ---
**Author:** ![Nathan\_Reese](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nathan_reese/32/84829_2.png) [@Nathan\_Reese](https://discuss.elastic.co/u/Nathan_Reese)\ **Post date:** [June 21, 2021, 2:02pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/8 "2021-06-21T14:02:26Z")
It is advised to upgrade both elasticsearch and kibana to the same minor as kibana may request elasticsearch APIs specific to that minor version. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 19, 2021, 2:02pm UTC](https://discuss.elastic.co/t/kibana-map-date-format/276369/9 "2021-07-19T14:02:54Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.