Views with variable date logic
I am working on a reverse auction system. Listings can be set to be visible for 3,5 or 7 days and I store this data, along with the created and end epoch in the object. What I want a view to do however is only bring back listings which have not ended, if i work this date calculation out in the map then the view result becomes stale as the map does not get re run on every query, neither can it for scalability. Currently I'm returning the max period of 7 days and trimming out the lesser days that have ended in code. But this is horrible, i was wondering what you would suggest?