# "now/d" in table filter giving 01:00 and not midnight **URL:** \ **Category:** Kibana\ **Created:** [May 24, 2019, 11:19am UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629 "2019-05-24T11:19:45Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Duella](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@Duella](https://discuss.elastic.co/u/Duella)\ **Post date:** [May 24, 2019, 11:19am UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/1 "2019-05-24T11:19:46Z")
![Capture](https://us1.discourse-cdn.com/elastic/original/3X/e/7/e79d401e2011ec3b08f9eddfa219e526be577d19.png) I am trying to compare the count of errors today from midnight to now to data from a week ago for the same interval. I am using filters to do this, however "now/d" seems to be starting from 1am rather than midnight, but still stretching to the correct current time. I thought it may be an issue caused by British Summer Time, but the fact that the final time is correct makes me think this is incorrect. I also need the absolute and percentage difference between these two values. Is there a different filter I should be using? If this task is not possible using a table, is it possible to do this using a different visualisation? I am having a lot of issues with the accuracy of the visual builder in relation to the data I am expecting, so I would rather not use it! ---
**Author:** ![Duella](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@Duella](https://discuss.elastic.co/u/Duella)\ **Post date:** [May 27, 2019, 2:09pm UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/2 "2019-05-27T14:09:56Z")
Has anyone else run into this issue? Has it been reported as a bug? ---
**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\ **Post date:** [May 27, 2019, 4:34pm UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/3 "2019-05-27T16:34:25Z")
Hi, That looks like a bug. Can you please log it here? > **[elastic/kibana](https://github.com/elastic/kibana/issues)** > > :bar\_chart: Kibana analytics and search dashboard for Elasticsearch - elastic/kibana Thanks, Bhavya ---
**Author:** ![Duella](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@Duella](https://discuss.elastic.co/u/Duella)\ **Post date:** [May 28, 2019, 8:29am UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/4 "2019-05-28T08:29:28Z")
Thank you for responding, I will put that in now. Can you think of any work round we can use in the meantime? Kind regards, **Belinda Armstrong** ---
**Author:** ![bhavyarm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/bhavyarm/32/22392_2.png) [@bhavyarm](https://discuss.elastic.co/u/bhavyarm)\ **Post date:** [May 28, 2019, 12:33pm UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/5 "2019-05-28T12:33:07Z")
@lukeelmers / @markov00 any inputs. Thanks, Bhavya ---
**Author:** ![Duella](https://avatars.discourse-cdn.com/v4/letter/d/d07c76/32.png) [@Duella](https://discuss.elastic.co/u/Duella)\ **Post date:** [May 28, 2019, 1:08pm UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/6 "2019-05-28T13:08:29Z")
I have currently amended the date range to “now/d-1h” to “now” and “now-7d/d-1h” to “now-7d”, however when the clocks change again, I imagine it won’t work. Kind regards, **Belinda Armstrong** ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [June 25, 2019, 1:08pm UTC](https://discuss.elastic.co/t/now-d-in-table-filter-giving-01-00-and-not-midnight/182629/7 "2019-06-25T13:08:33Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.