# Diff between two date fields in kibana
**URL:** https://discuss.elastic.co/t/diff-between-two-date-fields-in-kibana/130952
**Category:** Kibana
**Created:** [May 8, 2018, 7:55am UTC](https://discuss.elastic.co/t/diff-between-two-date-fields-in-kibana/130952 "2018-05-08T07:55:30Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@1862347ba9566e72a47d](https://discuss.elastic.co/u/1862347ba9566e72a47d)
#### Post date: [May 8, 2018, 7:55am UTC](https://discuss.elastic.co/t/diff-between-two-date-fields-in-kibana/130952/1 "2018-05-08T07:55:31Z")
A document with several date fields.
How can I determine the delta of time in days, for example, between several dates in this document?
Dates can be different years, i.e. It is necessary to minus the older date.
For example, use `doc['date1'].date.dayOfYear - doc['date0'].date.dayOfYear` a negative number is obtained. Because these dates are from different years. How to get the difference?
---
### Author:  [@Stacey\_Gammon](https://discuss.elastic.co/u/Stacey_Gammon)
#### Post date: [May 8, 2018, 1:13pm UTC](https://discuss.elastic.co/t/diff-between-two-date-fields-in-kibana/130952/2 "2018-05-08T13:13:45Z")
Try calculating the difference using `doc[date1].date.millis` or `doc[date1].value` and then converting the number into the value you want (e.g. days).
This stack overflow gives some more details that I think will help you: [https://stackoverflow.com/questions/32658639/how-to-calculate-difference-between-two-datetime-in-elasticsearch](https://stackoverflow.com/questions/32658639/how-to-calculate-difference-between-two-datetime-in-elasticsearch)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 5, 2018, 1:20pm UTC](https://discuss.elastic.co/t/diff-between-two-date-fields-in-kibana/130952/3 "2018-06-05T13:20:43Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.