# Difference in two timestamp fields
**URL:** https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151
**Category:** Kibana
**Created:** [May 12, 2020, 7:08am UTC](https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151 "2020-05-12T07:08:00Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@sama.sowjanya](https://discuss.elastic.co/u/sama.sowjanya)
#### Post date: [May 12, 2020, 7:08am UTC](https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151/1 "2020-05-12T07:08:00Z")
Hello
I have two fields closed\_date and open\_date which are in date format and are aggregatable. i want to create a new scripted field using scripting to calculate the difference between them.
We are using ELK 7.3.0 version
My fields are as below...
closed\_date = Feb 16, 2020 @ 15:00:06.000,
open\_date = Feb 13, 2020 @ 14:40:06.000
Need to calculate (closed\_date - open\_date).
Thank you.
---
### Author:  [@jsanz](https://discuss.elastic.co/u/jsanz)
#### Post date: [May 13, 2020, 8:55am UTC](https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151/2 "2020-05-13T08:55:48Z")
This will be helpful
> [@Kibana painless- Difference in dates in days](https://discuss.elastic.co/t/kibana-painless-difference-in-dates-in-days/169201/2):
>
> You could do something like the following: return (doc['date2'].value.millis - doc['date1'].value.millis) / 1000 / 60 / 60 / 24;
I tried a simple script query with the sample ecommerce dataset and works as expected. I just changed the `.millis` property by the recommended method `.toInstant().toEpochMilli()`.
```
GET kibana_sample_data_ecommerce/_search
{
"_source": ["products.created_on", "order_date"],
"size": 2,
"script_fields": {
"difference": {
"script": {
"source": "(doc['order_date'].value.toInstant().toEpochMilli() - doc['products.created_on'].value.toInstant().toEpochMilli()) / 1000 / 60 / 60 / 24"
}
}
}
}
```
With the result:
```
{
"took" : 0,
"timed_out" : false,
"_shards" : {
"total" : 1,
"successful" : 1,
"skipped" : 0,
"failed" : 0
},
"hits" : {
"total" : {
"value" : 4675,
"relation" : "eq"
},
"max_score" : 1.0,
"hits" : [
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "XAGPn3AB9W_0WIVNAOX7",
"_score" : 1.0,
"_source" : {
"order_date" : "2020-03-16T09:28:48+00:00",
"products" : [
{
"created_on" : "2016-12-26T09:28:48+00:00"
},
{
"created_on" : "2016-12-26T09:28:48+00:00"
}
]
},
"fields" : {
"difference" : [
1176
]
}
},
{
"_index" : "kibana_sample_data_ecommerce",
"_type" : "_doc",
"_id" : "XQGPn3AB9W_0WIVNAOX7",
"_score" : 1.0,
"_source" : {
"order_date" : "2020-03-15T21:59:02+00:00",
"products" : [
{
"created_on" : "2016-12-25T21:59:02+00:00"
},
{
"created_on" : "2016-12-25T21:59:02+00:00"
}
]
},
"fields" : {
"difference" : [
1176
]
}
}
]
}
}
```
---
### Author:  [@sama.sowjanya](https://discuss.elastic.co/u/sama.sowjanya)
#### Post date: [May 14, 2020, 6:31am UTC](https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151/3 "2020-05-14T06:31:41Z")
Thank you @jsanz
Script is working fine
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [June 11, 2020, 6:31am UTC](https://discuss.elastic.co/t/difference-in-two-timestamp-fields/232151/4 "2020-06-11T06:31:41Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.