Only Displaying Events that are Current

I have limited knowledge of coding, and created a small database to show banners/events. I then linked it to a wix list and it displayed quite well. The part I thought would be more simple was pulling down banners once the date has past. I played with filter and deleting events but then realized this was something I need to manually do each day, I’m hoping to automate this for vacation, holidays etc.

I see the following thread but need more complete instructions on removing a row once date has passed. I searched on my own, but am looking for a simple answer.

Hi,
How does the banners stored?
Roi.

I used a database and synced it to wixs grids & lists. I have the events listed by dates, and showing only 9 at a time. Currently when an event/date is old I just delete it from the live database.

But I would like an automatic update that removes the event the day before so people can no longer register for the event. I thought filters, user input/menus/date picker, cron-job all might help . But I need a simple answer as I have limited knowledge. My database “Banners” has a “date removed” column. And I don’t really want to delete data, just show only current events before todays date.