Order By

I am using this

' strSQL = "SELECT jobtable.jobname, jobtable.postdate FROM jobtable ORDER BY postdate DESC;"

Postdate is in format 12/5/2003

Problem is when I get above 9,  say 10 the two digit goes to the bottom when it should be up top as it is higher.  I am geting the system date with this

'value="<% Response.Write(Date)%>

Is there any way to make it format like this:  12/07/2003 instead of 12/7/2003,  I find when i manually input the date that like it works fine.

Thanks

or you can convert it in the SQL statement and leave your database alone

SELECT jobtable.jobname, jobtable.postdate FROM jobtable ORDER BY Cdate(postdate) DESC

that'll for sure work in SQL, dunno about Access, but you can try it