musicales - 3:25 pm on Jul 8, 2011 (gmt 0)
I'm tryng to write some code that updates one of 10,000 products every minute - as there are 10080 minutes in a week it seems obvious to perform a function to work out how many minutes since, say 12am Monday morning and update the corresponding product - I want it to roll around the list each week rather than attempting to update them all in one go which uses a lot of resources. If we assign Monday to being day 1, then it should be some simple equation to get the current minute since 0.00 on day 1.
But I've made several attempts and I don't think they're right. Any brainiacs out there can help with this one?