# Use date range in DSL/KQL query

**URL:** <https://discuss.elastic.co/t/use-date-range-in-dsl-kql-query/379405>\
**Category:** Kibana\
**Created:** [June 23, 2025, 9:13am UTC](https://discuss.elastic.co/t/use-date-range-in-dsl-kql-query/379405 "2025-06-23T09:13:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco\_zwaan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/remco_zwaan/32/129991_2.png) [@remco\_zwaan](https://discuss.elastic.co/u/remco_zwaan)\
**Post date:** [June 23, 2025, 9:13am UTC](https://discuss.elastic.co/t/use-date-range-in-dsl-kql-query/379405/1 "2025-06-23T09:13:54Z")

</div>

We have a availability\_updated\_at field (date) which is automaticly updated when our partners update the availability. I want to filter out wich accos or NOT update

`NOT presentation : "as_parent" and NOT availability_updated_at : * and NOT channel : "open_gds"`

This works ok. Next step is get all accos they have NOT update 1 or 2 or 3 or 4 ect months  
ago. What value must i put after availability\_updated\_at : ?

remco

---

<div class="post-metadata">

**Author:** ![esijati](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/esijati/32/122104_2.png) [@esijati](https://discuss.elastic.co/u/esijati)\
**Post date:** [June 23, 2025, 9:27am UTC](https://discuss.elastic.co/t/use-date-range-in-dsl-kql-query/379405/2 "2025-06-23T09:27:54Z")

</div>

can you try:

in lucene:

```auto
{
"range" : {
"availability_updated_at" : {
"lt" : "now-2M/M"
}
}
}

```

in KQL:  
`availability_updated_at < now-2M/M`