Hi Team, I want to calculate time difference between two times (incident created time & incident updated time fields). I'm trying to create a scripted field for this...but getting error while loading. My scripts looks like this doc['incident_update_timestamp'].value - doc['wit_cell_16_Value'].va…

It sounds like at least one of your fields is a date, not a number. If a field shows up as date type in your mapping, you have to access the value with doc['myFieldNameHere'].value.millis to get the timestamp value as a number. Also see here Kibana painless- Difference in dates in days

Painless script to get date difference

Elastic Stack Kibana

Purushoth_Kumar (Purushoth Kumar) March 13, 2020, 8:51am 3

Thanks alot @flash1293...I could able to get the desired outcome

Topic		Replies	Views
Trying to calculate time difference using scripted fields Kibana	6	2378	October 2, 2019
Datefields time difference in scripted field produce zero always Kibana	2	353	February 28, 2019
Calculate Difference between 2 Dates in Scipted Field Kibana	4	6867	November 19, 2018
Painless script to calculate elapsed time between two fields Kibana	14	1551	July 8, 2021
Painless Script to calculate time difference between 2 dates Elasticsearch painless	2	5520	July 15, 2022

Painless script to get date difference

Related topics