Rotate through views result weekly I have a content type called "Tips of the Week" and in a Views block. I would like to display one tip at a time, but have it display the next tip in a week's time based on the content's post date. If a tip is added, it is entered into the rotation of the tips.

A tip might not be added every week, so I do not think it can be solely based on the post date of the tips. Instead, is there a way to cycle through the offset.

I have tried different sort criteria, and the closest one I could find was random, but that changes every time the page loads.

How can I accomplish this?

Thanks!
Add a date field to your tip of the week content type.  That date field will indicate when the tip becomes visible on the site.  Order your view by date (descending), and filter out all entries where the date field is greater than the current date.

If you want to write some code, you can add a hook that runs when you submit the form, and, if you leave the date field blank, have it select the maximum value of the date field out of the database, add a week to that, and fill the date in automatically.