What’s the best way to change a query to advance to a certain date as mentioned below?
- Display the current query results, i.e., June 15, 2022.
- Set a date ‘trigger’ to automatically display that data for one calendar year then change the query on June 15, 2023 to hide previous 2022 data and display the new 2023 data.