# KQL from @timestamp until 7days offset

**URL:** https://discuss.elastic.co/t/kql-from-timestamp-until-7days-offset/294819
**Category:** Kibana
**Tags:** kql-kibana-query-language
**Created:** [January 19, 2022, 1:37pm UTC](https://discuss.elastic.co/t/kql-from-timestamp-until-7days-offset/294819 "2022-01-19T13:37:49Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![baddack](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/baddack/32/100535_2.png) [@baddack](https://discuss.elastic.co/u/baddack)
#### Post date: [January 19, 2022, 3:22pm UTC](https://discuss.elastic.co/t/kql-from-timestamp-until-7days-offset/294819/4 "2022-01-19T15:22:59Z")

</div>

I did some tests and the behavior is a bit weird.

I have the same result by doing this :

`@timestamp >= "now-1d/d+11h" AND @timestamp <= "now-1d/d+13h"`

**OR** this :

`@timestamp <= "now-1d/d+13h"`

I tried everything but I can't go back any further than today's date at midnight !

Here another link that I found very helpful to understand :

**[Several date math questions](https://discuss.elastic.co/t/several-date-math-questions/27453/3)**

I found it very easy to understand but in practice I couldn't get it to work beyond today's intervals

---

_[View the full topic](https://discuss.elastic.co/t/kql-from-timestamp-until-7days-offset/294819)._