Date Column difference in days using Scripted fields

[Ram18 (Ramanand)]

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 to handle this and get the exact difference in days.

doc['received_dt'].date.dayOfYear- doc['start_dt'].date.dayOfYear

[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?

[Ram18 (Ramanand)]

Liza, Yes the discussion post helped me to narrow down the things. Thanks!