# Painless Script to calculate time difference between 2 dates

**URL:** <https://discuss.elastic.co/t/painless-script-to-calculate-time-difference-between-2-dates/307335>\
**Category:** Elasticsearch\
**Tags:** painless\
**Created:** [June 16, 2022, 3:57am UTC](https://discuss.elastic.co/t/painless-script-to-calculate-time-difference-between-2-dates/307335 "2022-06-16T03:57:57Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![RabBit\_BR](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rabbit_br/32/82261_2.png) [@RabBit\_BR](https://discuss.elastic.co/u/RabBit_BR)\
**Post date:** [June 17, 2022, 10:46pm UTC](https://discuss.elastic.co/t/painless-script-to-calculate-time-difference-between-2-dates/307335/2 "2022-06-17T22:46:38Z")

</div>

Hi @Avnish_Singh .

I don't know if it's exactly like your example but with your script code I got the desired output.

```auto
POST teste/_doc
{
  "col1": "2022-06-16T09:00:00.000",
  "col2": "2022-06-16T09:10:07.999"
}

GET teste/_search
{
  "script_fields": {
    "time_diff": {
      "script": {
        "source": """
          def diffInMs = doc['col2'].value.getMillis() - doc['col1'].value.getMillis();
          return new SimpleDateFormat('HH:mm:ss.SSS').format(diffInMs);
      """
      }
    }
  }
}

```

---

_[View the full topic](https://discuss.elastic.co/t/painless-script-to-calculate-time-difference-between-2-dates/307335)._