How can I filter database data to only show the item marked with today's date?

[hello42115]

Hello All,

Every day in December, my client’s website will be featuring 1 new Christmas performance video. (31 days. 31 videos) Only 1 video will be shown at a time. We need a way for each day’s featured video to automatically update to be displayed, but only when it’s that video’s day to be featured.

We are organizing these videos into a database that will look like this:

The final layout will look something like this:

So the question is:

How can I automate the daily updates?

Or perhaps, how can I get each database item to be featured only when the date in the “Date to Air” column matches today’s date?

Thanks everyone!

[yisrael-wix]

You can query the video database collection based on the date to provide the current day’s video. Then set the video player to play that video.