How Do You Sort On Two Date Fields ?

I am trying to order two date columns. One Ascending the
other Descending. I am using the Orders table of Northwind in SQL
Server. No idea why, but it only sorts on the first column I set
criteria on. I think you have to convert it to date as it gets stored
as date/time...


I tried

SELECT     TOP 100 PERCENT OrderID, CustomerID, EmployeeID, OrderDate,
CONVERT(char(10), RequiredDate, 103) AS RequiredDate,
CONVERT(char(10),
                     ShippedDate, 103) AS ShippedDate, ShipVia,
Freight, ShipName, ShipAddress, ShipCity, ShipRegion
FROM         dbo.Orders
ORDER BY RequiredDate, ShippedDate DESC


But odd results occured

Any ideas appreciated