# Problem in difference between two dates
**URL:** https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655
**Category:** Kibana
**Created:** [February 27, 2018, 12:38pm UTC](https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655 "2018-02-27T12:38:15Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@nabilberd](https://discuss.elastic.co/u/nabilberd)
#### Post date: [February 27, 2018, 12:38pm UTC](https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655/1 "2018-02-27T12:38:15Z")
Hello ,
I have problem with this script :
if ( doc['entities.status'].value == doc['entities.statusesInformation.statusName'].value ) {
return doc['entities.executionDate'].date - doc['entities.creationDate'].date ;
}
When i execute it, i got this error :
lang":"painless","caused\_by":{"type":"class\_cast\_exception","reason":"Cannot apply [-] operation to types [org.joda.time.MutableDateTime] and [org.joda.time.MutableDateTime]."}}}]},"status":500}
Thank you for your helps.
---
### Author:  [@tylersmalley](https://discuss.elastic.co/u/tylersmalley)
#### Post date: [February 27, 2018, 10:17pm UTC](https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655/2 "2018-02-27T22:17:37Z")
As the error states, you can use that operator on the date.
Here are supported date functions: [https://www.elastic.co/guide/en/elasticsearch/reference/6.2/modules-scripting-expression.html#\_date\_field\_api](https://www.elastic.co/guide/en/elasticsearch/reference/6.2/modules-scripting-expression.html#_date_field_api)
---
### Author:  [@nabilberd](https://discuss.elastic.co/u/nabilberd)
#### Post date: [February 28, 2018, 7:56am UTC](https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655/3 "2018-02-28T07:56:17Z")
Thank you for your reply.
I solved the problem with date in painless but i have another error ( null pointer exception ) with this :
doc['entities.statusesInformation.statusName'].value )
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 28, 2018, 7:56am UTC](https://discuss.elastic.co/t/problem-in-difference-between-two-dates/121655/4 "2018-03-28T07:56:25Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.