Filter Events calendar by DateTime

Hi Andreas. Thanks - any help you can give will be hugely appreciated.

I’ve attached a shot of the data structure - past_gig is the boolean that I created to make it easy to mark a gig as in the past (and therefore not displayed), and the site is currently filtering the data using that (successfully) - it’s the automation of marking this column (I would assume on page views as I’ve not seen anything similar to running a cron job) which I can’t work out - I spent about an hour reading the help yesterday to little avail. I got as far as thinking that a hook on ‘Before Get’ would be needed, but I couldn’t make much of the documentation, or how to iterate through the data while doing this.

As you can see, this is some of the table, but there are other entries, and those past ones are marked with the tick in past_gig and don’t display (there are others further down that don’t currently have a tick).

Many thanks