> The reason being when I store this into a sql database
> and sort it using a sql statement say by ascending order,
> it comes out as ...
dates are stored in databases as some humungous integer measuring the number of days from january 1, 0000 or some other base date
dates are always converted, both going into a database (being stored) and coming out (being queried)
so if you are not getting the right display format on dates that you are querying, then you must change the way you format the date in the SELECT (you could also do it in ASP, i suppose, but it's much easier to do it in the SELECT)
if you are using Microsoft Access, check out the FORMAT function in the help