Annually Change Query Dynamically

What’s the best way to change a query to advance to a certain date as mentioned below?

  1. Display the current query results, i.e., June 15, 2022.
  2. 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.
Community Page
Last updated: