Can anyone tell me the code, to order a recordset by the date. Programming in ASP and VBScript.

---------------------
David Behan - bmor.com

You have a db field containing dates and want to sort on them?

Try:

SELECT Whatever, WhateverElse FROM TableName ORDER BY DateFieldName ASC


Use ASC, Acsending or DESC, Descending

Regards

Owen.

Multiple Parameter UD4 / Access 2000 Database Search Tutorial:
www.tdsf.co.uk/tdsfdemo

Thanks, got it in the mean time. Wasn't working before cause date/time was not set as the field type in the database. Working properly and understand it now.

Thanks.

---------------------
David Behan - bmor.com