How can I filter a repeater by using a dropdown and just show the current and future results from the dababase

Hi, I have a database with some events. Now I have created a dropdown menu to filter these events by special, freeshots and sales . Furthermore I have a datepicker that picks the events in the next 3 days. I already added some code that allows me to hide The events from the past. So it’s up to dat. The problem is when I use the dropdown for example to just show the events with “freeshots” it also shows the events from the past with the label “freeshots”. So it shows all the results from the database
But I just want them to see the current and future events. Also each event has a date and time.
Can someone help me to find a solution? I’m really struggling.
Thank you!

Hi.

It seems that you are using or() to filter your database. You need to use and() instead.

Should you need further assistance, i nclude any relevant screenshots, code, and URLs to make it easier for others to understand the problem.

Good luck!