Hi, I am trying to get the difference between 2 date columns in days. I have used painless language and created a scripted field column. The issue here is, the difference in days between the end of the year and start of the next year creates problem and getting wrong values. please let me know, how…

Date Column difference in days using Scripted fields

LizaD (Liza Dayoub) April 24, 2019, 7:57pm 2

Hi! I found this discuss post that might be similar to what you are asking:

Can you check it out and see if it helps?

Topic		Replies	Views
Kibana painless- Difference in dates in days Kibana	2	7402	March 20, 2019
Date fields comparison Kibana	3	1692	June 9, 2021
Painless Scripted Field Based on Condition to Subtract Dates to get days Kibana	2	1370	March 11, 2020
Problems with date subtraction Kibana	2	2805	June 23, 2017
Diff between two date fields in kibana Kibana	2	15621	June 5, 2018