# How can I use %{+yyyy.mm.dd} in input?

**URL:** <https://discuss.elastic.co/t/how-can-i-use-yyyy-mm-dd-in-input/231535>\
**Category:** Logstash\
**Created:** [May 7, 2020, 12:16pm UTC](https://discuss.elastic.co/t/how-can-i-use-yyyy-mm-dd-in-input/231535 "2020-05-07T12:16:27Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jinjinbari](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jinjinbari](https://discuss.elastic.co/u/jinjinbari)\
**Post date:** [May 7, 2020, 12:16pm UTC](https://discuss.elastic.co/t/how-can-i-use-yyyy-mm-dd-in-input/231535/1 "2020-05-07T12:16:27Z")

</div>

Hello.

I want to use date variable in input, like below  
`input { elasticsearch{ hosts => ["localhost"] index => "test-%{+yyyy-MM-dd}" codec => "json" } }`  
but it occur error like this.  
Error: [404] {"error":{"root\_cause":[{"type":"index\_not\_found\_exception","reason":"no such index [test-%{+yyyy-MM-dd}]","resource.type":"index\_or\_alias","resource.id":"test-%{+yyyy-MM-dd}","index\_uuid":"_na_","index":"test-%{+yyyy-MM-dd}"}],"type":"index\_not\_found\_exception","reason":"no such index [test-%{+yyyy-MM-dd}]","resource.type":"index\_or\_alias","resource.id":"test-%{+yyyy-MM-dd}","index\_uuid":"_na_","index":"test%{+yyyy-MM-dd}"},"status":404}

How can I use?

Thank you

---

<div class="post-metadata">

**Author:** ![Badger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/badger/32/25190_2.png) [@Badger](https://discuss.elastic.co/u/Badger)\
**Post date:** [May 7, 2020, 3:55pm UTC](https://discuss.elastic.co/t/how-can-i-use-yyyy-mm-dd-in-input/231535/2 "2020-05-07T15:55:20Z")

</div>

> [@jinjinbari](#):
>
> input { elasticsearch{ hosts =\> ["localhost"] index =\> "test-%{+yyyy-MM-dd}" codec =\> "json" } }

A sprintf reference to a date, such as %{+yyyy-MM-dd} uses the value of @timestamp on an event to fill in the date. When the elasticsearch input is initializing there is no event, so there is no @timestamp field, so this does not work.

You might be able to use an environment variable. See [here](https://discuss.elastic.co/t/date-pattern-in-file-input-path/100538/3) for an example.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 4, 2020, 3:55pm UTC](https://discuss.elastic.co/t/how-can-i-use-yyyy-mm-dd-in-input/231535/3 "2020-06-04T15:55:25Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.