I wish to retrieve records and display them ordered by "purchaseDate" a Date/Time data type in Access table. But my statement does not seem to work. <BR><BR>Please take a look and advise:<BR><BR>function GetPurchase<BR>dim sql,rs<BR>set rs = Server.CreateObject("ADODB.RecordSet")<BR> <BR>sql = "Select o_id as ""Purchase id"",purchaseDate as ""Date Initiated"", p_title as ""Project title"",totalAmt as ""Total Amount"", status as ""Current Status"" from purchase where staff_id = &#039"+user+"&#039 order by purchaseDate"<BR>rs.open sql,dbConn<BR>set GetPurchase = rs<BR>end function<BR><BR>Thanks.<BR>