# Date Column difference in days using Scripted fields

**URL:** <https://discuss.elastic.co/t/date-column-difference-in-days-using-scripted-fields/178255>\
**Category:** Kibana\
**Created:** [April 24, 2019, 12:54pm UTC](https://discuss.elastic.co/t/date-column-difference-in-days-using-scripted-fields/178255 "2019-04-24T12:54:15Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![LizaD](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/lizad/32/51074_2.png) [@LizaD](https://discuss.elastic.co/u/LizaD)\
**Post date:** [April 24, 2019, 7:57pm UTC](https://discuss.elastic.co/t/date-column-difference-in-days-using-scripted-fields/178255/2 "2019-04-24T19:57:44Z")

</div>

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

> [@Kibana painless- Difference in dates in days](https://discuss.elastic.co/t/kibana-painless-difference-in-dates-in-days/169201):
>
> 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](https://www.elastic.co/blog/using-painless-kibana-scripted-fields)

Can you check it out and see if it helps?

---

_[View the full topic](https://discuss.elastic.co/t/date-column-difference-in-days-using-scripted-fields/178255)._