# Filter Collection List by Date

**URL:** <https://community.weweb.io/t/filter-collection-list-by-date/1194>\
**Category:** Ask us anything\
**Created:** [September 28, 2022, 10:42pm UTC](https://community.weweb.io/t/filter-collection-list-by-date/1194 "2022-09-28T22:42:21Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![foliodc](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/foliodc/32/761_2.png) [@foliodc](https://community.weweb.io/u/foliodc)\
**Post date:** [September 28, 2022, 10:42pm UTC](https://community.weweb.io/t/filter-collection-list-by-date/1194/1 "2022-09-28T22:42:21Z")

</div>

Am I missing the option to filter by greater than / less than? I would like to split a list of multi-day events into current ( ex. “start” is _less_ than today & and “end” is _greater_ than today), recent, and upcoming. I can do this in the backend but I have to make three+ api calls every time the page is loaded instead of one… and I can’t do it with static collections at all.

 ![Snip20220928_6](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/4/4b8b8486119b66967ec2cc651598ad93e1389a3e.png)

Maybe this is possible by binding with a formula?

Thank you!

---

<div class="post-metadata">

**Author:** ![khairul](https://avatars.discourse-cdn.com/v4/letter/k/a88e4f/32.png) [@khairul](https://community.weweb.io/u/khairul)\
**Post date:** [September 28, 2022, 11:25pm UTC](https://community.weweb.io/t/filter-collection-list-by-date/1194/2 "2022-09-28T23:25:29Z")

</div>

the datatype of the date is string, so that is the reason. How do you collect the date value?

---

<div class="post-metadata">

**Author:** ![foliodc](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/foliodc/32/761_2.png) [@foliodc](https://community.weweb.io/u/foliodc)\
**Post date:** [October 3, 2022, 1:49pm UTC](https://community.weweb.io/t/filter-collection-list-by-date/1194/3 "2022-10-03T13:49:41Z")

</div>

Ok I see that now. Xano “date” option comes through as a string like “2022-09-10”. I created a new field as a timestamp and it works. Thank you
