# Compare Dates in Script Query
**URL:** https://discuss.elastic.co/t/compare-dates-in-script-query/125761
**Category:** Elasticsearch
**Created:** [March 27, 2018, 1:28pm UTC](https://discuss.elastic.co/t/compare-dates-in-script-query/125761 "2018-03-27T13:28:44Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@TomTom](https://discuss.elastic.co/u/TomTom)
#### Post date: [March 27, 2018, 1:28pm UTC](https://discuss.elastic.co/t/compare-dates-in-script-query/125761/1 "2018-03-27T13:28:45Z")
I'm using Painless to create a filter, but when i use two dates this error happens:
```
"script": "doc['creation_date'].value > doc['update_date'].value",
"lang": "painless",
"caused_by": {
"type": "class_cast_exception",
"reason": "Cannot apply [>] operation to types [org.joda.time.MutableDateTime] and [org.joda.time.MutableDateTime]."
}
```
This the date type of this fields:
```
"field_name": {
"type": "date",
"index": true,
"format": "strict_date_time_no_millis"
},
```
I need convert this dates to epoch?
---
### Author:  [@TomTom](https://discuss.elastic.co/u/TomTom)
#### Post date: [March 27, 2018, 1:38pm UTC](https://discuss.elastic.co/t/compare-dates-in-script-query/125761/2 "2018-03-27T13:38:55Z")
Solved: [Comparison (\<) not supported on datetime fields anymore since upgrade to 6.1](https://discuss.elastic.co/t/comparison-not-supported-on-datetime-fields-anymore-since-upgrade-to-6-1/118008)
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [April 24, 2018, 1:39pm UTC](https://discuss.elastic.co/t/compare-dates-in-script-query/125761/3 "2018-04-24T13:39:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.