# Subtraction between current date and doc created date

**URL:** <https://discuss.elastic.co/t/subtraction-between-current-date-and-doc-created-date/326405>\
**Category:** Kibana\
**Created:** [February 24, 2023, 6:30am UTC](https://discuss.elastic.co/t/subtraction-between-current-date-and-doc-created-date/326405 "2023-02-24T06:30:06Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![stephenb](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/stephenb/32/40856_2.png) [@stephenb](https://discuss.elastic.co/u/stephenb)\
**Post date:** [February 24, 2023, 3:22pm UTC](https://discuss.elastic.co/t/subtraction-between-current-date-and-doc-created-date/326405/4 "2023-02-24T15:22:24Z")

</div>

Do you want Days in Integer or Float?

Field Type Double

```auto
long datenow = new Date().getTime();
long datewas = doc['@timestamp'].value.getMillis();
double days = (datenow - datewas) / 86400000.0;
emit (days);

```

Field Type Long

```auto
long datenow = new Date().getTime();
long datewas = doc['@timestamp'].value.getMillis();
long days = (datenow - datewas) / 86400000;
emit (days);

```

---

_[View the full topic](https://discuss.elastic.co/t/subtraction-between-current-date-and-doc-created-date/326405)._