Sorting recordsets

[EscapeUK]

I have an ADODB Recordset on of the fields is a date. How do I sout the records set records into date order.

 

[CajunCenturion]

have you tried using an ORDER BY clause in the query? Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[BaDi]

Something like:

Select * from (table)
Order By (field --> Date)

Good luck!

 

[EscapeUK]

Unfortunatly in my DB the dates are in varchar

 

[vbvictim]

You can also sort the recordset after you have it:

rsRecordset.Sort = "FieldName"

As far as it being in varchar, you may have to convert that field to a date in your SQL statement. That way you will be returning a date and then the sort will be ok. I'm pretty sure you can convert to date in your "order by" clause as well.