Message of the Day Logic/Architecture (New item from list each day)?

Message of the Day Logic (New item from list each day)?

I'm new to Xano but I've been building things for years. So, I'm familiar with data architecture but still feel like a noob in a lot of ways. Here's what I'd like to try to get to know Xano:

Display a new message each day on a front end, but have Xano handle all the logic for which message is retrieved.

What I have, and haven't, done and would love some advice on:
1. Store a database of messages. (Done)
2. Pull those messages into my front end. (Done)
3. Create a filter that randomizes the list and pulls out one (Done using array filters Shuffle + Shift, thanks to Michael).
4. Persist that message for one day only. (Not done)
5. Pull a new message for the next day and move the previous day's message to the bottom of the list. (Not done)
6. Eventually, the messages will loop/start over because I won't have thousands of entries - likely it'll be double digits at most. (Not done)

How would you go about thinking through this? Any ideas?

Thanks!