Hi,

I'm using SQL Server 2000 and am having a bit of trouble sorting by date

I've been getting incorrect results till I started converting the date to

YYYYMMDD - ORDER BY CONVERT(CHAR(8),a.Date_Assigned,112) DESC

The above is great if multiple records aren't inserted a day.

Does anyone know the code to convert a date to YYYYMMDDHHMMSS?

Cheers Al