How to sort by date?

<i><b>Originally posted by : Martin Johansson (info@sd-studios.com)</b></i><br /><br />How to sort by date when displaying database records?

<i><b>Originally posted by : Bob (bmacneal@dainrauscher.com)</b></i><br />Use "ORDER BY DateField ASC" or "ORDER BY DateField DESC" at the end of your query. You can also make the column header in your results table a hyperlink (to the same asp page) with the field name and sort type in the query string, so users can re-sort the table. <br /><br /><br />------------<br />Martin Johansson at 5/7/2000 9:01:20 AM<br /><br /><br />How to sort by date when displaying database records?