# ES|QL : Adding Days to a Date

**URL:** <https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288>\
**Category:** Kibana\
**Created:** [January 16, 2025, 5:32pm UTC](https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288 "2025-01-16T17:32:52Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [January 16, 2025, 5:32pm UTC](https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288/1 "2025-01-16T17:32:52Z")

</div>

Hello,

I was wondering if its possible with ES|QL to use a date field and add x amount of days to create a new date field.

Or would a runtime field work for this?  
Or would an ingest pipeline be the only solution.

Thanks,

---

<div class="post-metadata">

**Author:** ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)\
**Post date:** [January 16, 2025, 8:19pm UTC](https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288/2 "2025-01-16T20:19:50Z")

</div>

Thanks for reaching out, @erikg. Would something like this work for you?

```auto
POST _query?format=txt
{
  "query": """
    ROW original_date = "2025-01-01T00:00:00.000Z"
    | EVAL dt = TO_DATETIME(original_date)
    | EVAL dt_long = TO_LONG(dt)                  
    | EVAL add_ms = 5 * 24 * 60 * 60 * 1000         
    | EVAL new_long = dt_long + add_ms                 
    | EVAL new_date = TO_STRING(TO_DATETIME(new_long))
    | KEEP new_date
    | LIMIT 1
  """
}

```

The output you should get back is as follows:

```auto
        new_date        
------------------------
2025-01-06T00:00:00.000Z

```

---

<div class="post-metadata">

**Author:** ![erikg](https://avatars.discourse-cdn.com/v4/letter/e/91b2a8/32.png) [@erikg](https://discuss.elastic.co/u/erikg)\
**Post date:** [January 16, 2025, 9:00pm UTC](https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288/3 "2025-01-16T21:00:59Z")

</div>

Hey @jessgarson yes that would!  
thanks!

---

<div class="post-metadata">

**Author:** ![jessgarson](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jessgarson/32/129841_2.png) [@jessgarson](https://discuss.elastic.co/u/jessgarson)\
**Post date:** [January 16, 2025, 9:02pm UTC](https://discuss.elastic.co/t/es-ql-adding-days-to-a-date/373288/4 "2025-01-16T21:02:29Z")

</div>

Thanks, @erikg! Glad this works for you.