Order Dates by Nearest to Today (not just asc and desc)

[timtom]

Hi,
I wonder if there's a way to order a group of dates (not including year) by 'nearness' to today's date? (With events just gone at the end of the list)
So I could create a page displaying information like this...

thing - 9th July
thing - 20th August
thing - 25th August
thing - 15th December
thing - 23rd December
thing - 3rd January
thing - 15th February
thing - 20th May
thing - 3rd July

All my information is in an SQL database. Thanks if anyone knows a way of doing this.
Thanks
Sarah

[sub]WASN'T FIT ENOUGH FOR THE POLICE FORCE[/sub]​

 

[codestorm]

Really not sure what you're after here, but if it's what i'm thinking, how about something like:
Access:
select *
from table1
order by abs(datetimefield-now)
SQL Server:
select *
from table1
order by abs(datetimefield-current_timestamp) codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[snowboardr]

http://www.w3schools.com/sql/

this site will help you out

http://www.w3schools.com/asp/