I don't know how to do it automatically, so I do it manually for my game. I have weekly challenges that the player can download and compete in a leaderboard until the next week. So far that works great.
Basically the game downloads an INI file from my website, which it then reads and implements as a challenge, and every week I create a new leaderboard for the challenge.
There's probably an easier way but it works for me. If it was a daily thing I think I'd go crazy, hah.