Order by date question
Posted on 2004-08-10
I was wondering if there is a way to sort my query by date. But instead of having it sort the normal way (either ASC or DESC), is there a way to have it sort by the item that is closest to today's date and then move on.
So for instance. Say I have 10 items in my database ranging from Jan 04 to Dec 04. Is it possible to list the item closes to August 8th first and the forward and possibly moving the earlier items to the bottom of the page.
If anything. How can I display the item that is closest to todays date and future items.