# Collection Filtering to current date only

**URL:** <https://community.sitejet.io/t/collection-filtering-to-current-date-only/2011>\
**Category:** Collections\
**Tags:** cms\_collection\
**Created:** [September 28, 2022, 1:52pm UTC](https://community.sitejet.io/t/collection-filtering-to-current-date-only/2011 "2022-09-28T13:52:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vlad\_goldbyrd](https://avatars.discourse-cdn.com/v4/letter/v/7ea924/32.png) [@Vlad\_goldbyrd](https://community.sitejet.io/u/Vlad_goldbyrd)\
**Post date:** [September 28, 2022, 1:52pm UTC](https://community.sitejet.io/t/collection-filtering-to-current-date-only/2011/1 "2022-09-28T13:52:44Z")

</div>

Hey there SiteJet community!  
I’ve been trying to figure out how to filter collection items to today’s date only. I’m only able to use !#filter[columns.date] = gt/lt: now. When using just “now” I get an empty result. It almost looks like the function takes time into account because to get the collection item with today’s date I have to use gt: now. I thought about limiting the amount but unfortunately there are different amounts of the collection items for any given date.  
Please, advise.

---

<div class="post-metadata">

**Author:** ![Kalisperakichris](https://dub1.discourse-cdn.com/flex017/user_avatar/community.sitejet.io/kalisperakichris/32/3572_2.png) [@Kalisperakichris](https://community.sitejet.io/u/Kalisperakichris)\
**Post date:** [July 10, 2025, 8:16pm UTC](https://community.sitejet.io/t/collection-filtering-to-current-date-only/2011/2 "2025-07-10T20:16:31Z")

</div>

Hi @Vlad_goldbyrd,

You’re absolutely right — the `now` keyword includes both the **date and time** , so filtering with `= now` usually returns no results unless the timestamp matches exactly, down to the second.

🔍 If you want to filter **only items from today’s date** , regardless of their time, the best approach is to use a **date range filter**. Try this:

plaintext

```auto
!#filter[columns.date] = gte: today, lt: tomorrow

```

This will return all items:

- with a date **greater than or equal to today at midnight (00:00)**, and
- **less than tomorrow at midnight (00:00)**.

That way, you capture everything from today without worrying about time.

If `today` and `tomorrow` aren’t supported directly, try this version instead:

plaintext

```auto
!#filter[columns.date] = gte: {{date('today')}}, lt: {{date('tomorrow')}}

```

Also, make sure the `columns.date` field is stored as a **date type** , not a plain text string, so that the comparison works properly.

Hope this helps! Let us know if you need anything else. 👋

* * *

---

<div class="post-metadata">

**Author:** ![Andre](https://dub1.discourse-cdn.com/flex017/user_avatar/community.sitejet.io/andre/32/3459_2.png) [@Andre](https://community.sitejet.io/u/Andre)\
**Post date:** [July 11, 2025, 9:29am UTC](https://community.sitejet.io/t/collection-filtering-to-current-date-only/2011/3 "2025-07-11T09:29:22Z")

</div>

Hey Vlad,

Have you also checked our help article on the Collection Filter?

[https://help.sitejet.io/hc/en-us/articles/24275974402327-Collection-Filters](https://help.sitejet.io/hc/en-us/articles/24275974402327-Collection-Filters)