Sorting a Recordset

[bombdropVB]

Hi all i execute a SP but the Date field due to reasons beyond my control brings backa date as a string, dd/mm/yyyy

now i wish to sort on the date but it only looks at the dd aspect of the date due to the fact its a string

rsAuthors.Sort = "[Year Born], Au_ID DESC"


how can i get round this thanks

 

[FesterSXS]

maybe try something like this...

rsAuthors.Sort = "Year([Year Born]), Au_ID DESC"

Tony

http://www.SpiraxSarco.com

 

[bombdropVB]

Sorry no the problem was due to the fact the date is stored as a Varch in the DB i was returning it as a Varchar thus unable to sort correctley as a date. Fixed this by changing the way it is brought back from the SP

CONVERT(datetime,[Year Born] ,103)