# Filter by date in collection
**URL:** https://community.weweb.io/t/filter-by-date-in-collection/6311
**Category:** How do I?
**Tags:** supabase
**Created:** [January 10, 2024, 9:49pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311 "2024-01-10T21:49:08Z")
**Posts on this page:** 10
**Page:** 1
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 10, 2024, 9:49pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/1 "2024-01-10T21:49:08Z")
Hello.
I have a payments table and I would like to have a collection that brings in only the payments where the date \> an input and date \< input+1 day but I don’t have the option for less then or greater then in the query configuration. Yet I do get the options once I have created a collection. How can I achieve this?
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 10, 2024, 11:50pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/2 "2024-01-10T23:50:28Z")
Not possible for now. There is some alternate solutions, I suggest searching the forum.
---
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 11, 2024, 12:10am UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/3 "2024-01-11T00:10:19Z")
I was looking into other ways around this and discovered that my load table can be filtered by date?
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 11, 2024, 8:11am UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/4 "2024-01-11T08:11:54Z")
You’re joining the payment table with something? Or how is the query? Why is the payment\_date an object? I’d need to understand your structure
---
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 11, 2024, 8:47pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/5 "2024-01-11T20:47:46Z")
The payment date is just a timestampz field on the payments table im not doing any queries in supabase.
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 11, 2024, 10:25pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/6 "2024-01-11T22:25:41Z")
Then you just need to fetch the collection first with the filters disabled probably, or there is some other issue with the date. How does it look in the data sidebar? It looks like it’s an object of some sort.
---
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 11, 2024, 10:47pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/7 "2024-01-11T22:47:50Z")
I gave that a try, unfortunately no luck, here’s the data sidebar.
---
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 11, 2024, 10:51pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/8 "2024-01-11T22:51:45Z")
here is what supabase looks like too
---
### Author:  [@Broberto](https://community.weweb.io/u/Broberto)
#### Post date: [January 11, 2024, 11:01pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/9 "2024-01-11T23:01:21Z")
Probably weweb is interpreting the date in a wrong way @Alexis?
---
### Author:  [@sam1](https://community.weweb.io/u/sam1)
#### Post date: [January 15, 2024, 11:38pm UTC](https://community.weweb.io/t/filter-by-date-in-collection/6311/10 "2024-01-15T23:38:43Z")
I checked again today and the date was being interpreted correctly unsure what changed but its working now 🤷♂️