I do not get any sorting happening at all when I use your suggestion - any more suggestions

😉 Thanks

WHEN 'MSDue' then CASE CONVERT(VARCHAR(19),Job.[MS Due Date],120) WHEN '1753-01-01 00:00:00.000' Then '12-31-2049'

ELSE CONVERT(VARCHAR(19),Job.[MS Due Date],120)

End