I have an "Events" collection which holds information for events during the year. I want to be able to have two text boxes for "this month's event" and "next month's event".
I think the solution is to pass the value (e.g. this month or next month) to the collection filtered against the "Event Date"). I get the correct single item when filtering for either this or next month when directly filtering on the collection but I want to have both events on the same page dynamically populated.
In my head this is easy.
I can imagine a SQL query for this
Box 1: Select event_name where event_date = "this month"
Box 2: Select event_name where event_date = "next month"
Sadly my Corvid coding is not as good as old school database code
Appreciate any help