Here, you cant desc or asc the strings
select distinct convert(varchar(10),ut.TrackDate) as 'UserDate',
ud.UnitDepartmentName as 'Department'
from EquipmentTracking ut
inner join UnitDepartment ud on ud.UnitDepartmentID = ut.SectionID
order by convert(Datetime,ut.TrackDate,103) desc