sort a sql text field by date
Posted on 2007-03-28
I have a field in an sql database that I want to sort in a list. It's a text value that stores the file name where the data was imported from by its week range
How can I sort this field by date in the sql statement.
' here is my start
strSQL2 = "Select distinct RUNDATE from edstats"
Rs.Open strSQL2, Conn
if not Rs.EOF then
do until rs.EOF
RUNDATE = Rs("RUNDATE")
'this is what I want to display by date order soonest to oldest
RESPONSE.WRITE("<A href='LOADEXCEL.ASP?value="&rundate&"'>Week of "&rundate2&"<BR>")
set Rs = Nothing
set conn= nothing