# Stuck with something related to Date

**URL:** <https://discuss.elastic.co/t/stuck-with-something-related-to-date/54093>\
**Category:** Logstash\
**Created:** [June 27, 2016, 11:36pm UTC](https://discuss.elastic.co/t/stuck-with-something-related-to-date/54093 "2016-06-27T23:36:14Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kansei1983](https://avatars.discourse-cdn.com/v4/letter/k/7bcc69/32.png) [@kansei1983](https://discuss.elastic.co/u/kansei1983)\
**Post date:** [June 27, 2016, 11:36pm UTC](https://discuss.elastic.co/t/stuck-with-something-related-to-date/54093/1 "2016-06-27T23:36:14Z")

</div>

I am new to using the ELK stack and running into the following problem -\>

I have a CSV file with the following format -\>

"string1" , "string2" , "string3" , "2016-06-26" , "string4"

My mapping in elasticsearch creates properties for strings 1,2,3 and 4 of type string and a property of type date with the following format : yyyy-MM-dd"

My date filter looks like -\>

date {  
match =\> ["Timestamp", "yyyy-MM-dd"]  
target =\> "@timestamp"  
}

So far all is good .

I can see in Kibana that @timestamp is as expected , ( same as Timestamp )

However , I can't seem to get the following sorted out -\>

(1) My date is off by one . For example , if my date string in my csv file is 2016-06-26 , it shows up as 2016-06-25 in elasticsearch/kibana .

(2) The timepicker in Kibana doesn't work . Even assuming dates off by one , if i filter for records between 1 may 2016 to 31 may 2016 I would have expected it to show something . But this filtering does not work .

- note that i am able to build visualizations and dashboards and all the records get indexed .

Any help highly appreciated .

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [June 29, 2016, 6:55am UTC](https://discuss.elastic.co/t/stuck-with-something-related-to-date/54093/2 "2016-06-29T06:55:19Z")

</div>

Is it a TZ issue?  
Cause LS+ES assumes UTC, and then KB changes that to local based on the browser.

---

<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:** [July 6, 2017, 4:50am UTC](https://discuss.elastic.co/t/stuck-with-something-related-to-date/54093/3 "2017-07-06T04:50:31Z")

</div>