# How to filter date field by days and hours separately

**URL:** <https://discuss.elastic.co/t/how-to-filter-date-field-by-days-and-hours-separately/193946>\
**Category:** Elasticsearch\
**Created:** [August 6, 2019, 7:17am UTC](https://discuss.elastic.co/t/how-to-filter-date-field-by-days-and-hours-separately/193946 "2019-08-06T07:17:24Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [August 6, 2019, 12:03pm UTC](https://discuss.elastic.co/t/how-to-filter-date-field-by-days-and-hours-separately/193946/4 "2019-08-06T12:03:16Z")

</div>

you just take the minute into account as well, then you can model sth like 9:30. The date is always stored as UTC, you need to calculate offsets yourself.

---

_[View the full topic](https://discuss.elastic.co/t/how-to-filter-date-field-by-days-and-hours-separately/193946)._