# WHAT IS SCRIPT FOR FINDING MINIMUM OF DATES WHICH ARE IN strict\_date\_time\_no\_millis FORMAT IN KIBANA

**URL:** <https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839>\
**Category:** Kibana\
**Created:** [March 18, 2019, 5:31pm UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839 "2019-03-18T17:31:28Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![PRUDHVI\_CHOWDHARY\_NE](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@PRUDHVI\_CHOWDHARY\_NE](https://discuss.elastic.co/u/PRUDHVI_CHOWDHARY_NE)\
**Post date:** [March 18, 2019, 5:31pm UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/1 "2019-03-18T17:31:28Z")

</div>

FIND MINIMUM OF DATES WHICH ARE IN strict\_date\_time\_no\_millis FORMAT IN KIBANA PAINLESS SCRIPT FIELD

2019-03-14T11:36:49.635Z,  
2019-03-14T11:37:49.635Z,  
2019-03-14T11:34:49.635Z,

I have several dates like above in array.I need to find minimum of theses dates

---

<div class="post-metadata">

**Author:** ![tiagocosta](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tiagocosta/32/40045_2.png) [@tiagocosta](https://discuss.elastic.co/u/tiagocosta)\
**Post date:** [March 18, 2019, 5:57pm UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/2 "2019-03-18T17:57:09Z")

</div>

@PRUDHVI_CHOWDHARY_NE If I understood it correctly, I believe you will be able to use a common loop over the array (you can found some examples here [https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-examples.html](https://www.elastic.co/guide/en/elasticsearch/painless/master/painless-examples.html) )

And then just use the available Date functions to compare the dates until you found the minimum one:

> **[Using Painless in Kibana scripted fields
	  	 | Elastic](https://www.elastic.co/blog/using-painless-kibana-scripted-fields)**
>
> Kibana provides powerful ways to search and visualize data stored in Elasticsearch. For the purpose of visualizations, Kibana looks for fields defined in Elasticsearch mappings and presents them as op...

[https://docs.oracle.com/javase/8/docs/api/java/time/LocalDateTime.html#isBefore-java.time.chrono.ChronoLocalDateTime-](https://docs.oracle.com/javase/8/docs/api/java/time/LocalDateTime.html#isBefore-java.time.chrono.ChronoLocalDateTime-)

---

<div class="post-metadata">

**Author:** ![PRUDHVI\_CHOWDHARY\_NE](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@PRUDHVI\_CHOWDHARY\_NE](https://discuss.elastic.co/u/PRUDHVI_CHOWDHARY_NE)\
**Post date:** [March 19, 2019, 4:14am UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/3 "2019-03-19T04:14:17Z")

</div>

`Hello Tiago Costa`

I have an array of objects in every document of an index.  
for example  
"content " :[  
{  
"queryId": "20190314\_113638\_00349\_krexs",  
"query\_service\_entry\_time": "2019-03-14T11:36:38.201Z",  
"query\_service\_exit\_time": "2019-03-14T11:36:49.635Z",  
},  
{  
"queryId": "20190314\_113638\_00352\_krexs",  
"query\_service\_entry\_time": "2019-03-14T11:36:38.219Z",  
"query\_service\_exit\_time": "2019-03-14T11:36:49.765Z",  
},  
{  
"queryId": "20190314\_113638\_00353\_krexs",  
"query\_service\_entry\_time": "2019-03-14T11:36:38.236Z",  
"query\_service\_exit\_time": "2019-03-14T11:36:49.907Z",  
}  
]

What is the painless script for display minimum of query\_service\_entry\_time and maximum of query\_service\_exit\_time in array of objects in saved search

---

<div class="post-metadata">

**Author:** ![PRUDHVI\_CHOWDHARY\_NE](https://avatars.discourse-cdn.com/v4/letter/p/9f8e36/32.png) [@PRUDHVI\_CHOWDHARY\_NE](https://discuss.elastic.co/u/PRUDHVI_CHOWDHARY_NE)\
**Post date:** [March 19, 2019, 6:06am UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/4 "2019-03-19T06:06:24Z")

</div>

MAIN INTENSION IS HOW TO MAKE OBJECTS IN ARRAY WELL SUPPORTED IN KIBANA DASHBOARDS,SAVED SEARCH

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [March 25, 2019, 9:37pm UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/5 "2019-03-25T21:37:55Z")

</div>

Please don't use all caps, it's considered rude.

---

<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:** [April 22, 2019, 9:38pm UTC](https://discuss.elastic.co/t/what-is-script-for-finding-minimum-of-dates-which-are-in-strict-date-time-no-millis-format-in-kibana/172839/6 "2019-04-22T21:38:00Z")

</div>

Closed on April 22, 2019, 9:38pm UTC

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