Searching a list of dates for set ranges

Hi all,

I am really hoping I’ve not stitched myself up here. I’ve implemented a feature where users can set up recurring events. I am storing this in a ‘Dates’ field which is a list of dates, where all the dates for upcoming events are stored.

I am struggling to display simple searches such as all events on today, tomorrow or next week.

Should this be a back end flow to create multiple events with a singular date or can I manipulate the list of dates?

The only option I seem to have is ‘contains’ and I can’t build today, or a range, such as a week.