Filter Collection List by Date

[foliodc]

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.

Maybe this is possible by binding with a formula?

Thank you!

[khairul]

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

[foliodc]

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