Hi, using a table in Kibana Lens I can't get a formatted date at the "Log Date" column. The date format changes according to the time period. Below is the JSON I've been using and the screenshots with the issue { "took": 40, "timed_out": false, "_shards": { "total": 1, "successful": 1, "skip…

Hi @fefontana , That setting in the Lens panel can configure how fine the date bucket/histogram should be, and not the date formatter. At the moment there's not specific Lens option to format that date, rather a Kibana-wise option available in Advanced Settings named dateFormat:scaled where you ca…

Hi @fefontana @Marco_Liberati I Stand Corrected! This does not appear to work for Lens Table (works most everywhere else, I am surprised) @fefontana Apologies for the confusion, it is a good trick to know though There is another method to do this... Set the date format pattern for that field in i…

Thank you, Marco for your answer. I changed in "Advanced Options" the date format mask (to DD-MM-YYYY HH:mm:ss) and the date column shows the correct format, but not the correct value. If you take a look at the JSON, the first two rows shows wrong minutes and seconds, ie., 02-07-2021 12:00:00 (-03:…

Thank you Stephen for your response. I also changed the date format at the pattern field, but the result is the same as the screen at the previous post, no change. [image]

Good to Know! You could (should) probably use a runtime field too.. (the future of scripted fields) you can add right from the index pattern as well.

Discuss the Elastic Stack

Kibana Lens Table Date Format

Elastic Stack Kibana

fefontana (Franco Fontana) September 23, 2021, 8:16pm 6

The only way I found to get the right date vale was to create a scripted field like the image below:

Topic		Replies	Views
Is there a way to filter by date and not by date time in Kibana Lens? Kibana	9	1776	January 2, 2022
Date Format in Data Table Kibana	2	2232	February 7, 2019
Date Format for Monthly aggregated data table Kibana	1	36	May 2, 2025
Kibana date format mapping Kibana	6	2841	November 26, 2021
Date Problem In kibana VIsualization Kibana	8	678	October 16, 2019

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Kibana Lens Table Date Format

Related topics