Date Column difference in days using Scripted fields

[LizaD (Liza Dayoub)]

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

Kibana painless- Difference in dates in days

I have two date fields - Date1 and Date2, both are in date format I want to calculate days between the two dates. I tried doc['date2'].value - doc['date1'].value, this is not giving the expected return value

There is also this blog post: Using Painless in Kibana scripted fields | Elastic Blog

Can you check it out and see if it helps?