It looked like your DATE column is numeric, and we are sorting by that column. So you should be ok.
Even if it is not numeric, it would still be able to sort and pick the top 1. But, you have to be aware that string sort may not always give you the results you expect. For example, the query below returns 9 rather than 1100 because of the way string sort behaves. IF the data type was numeric you would have gotten 1100 instead.
CREATE TABLE #tmp (v VARCHAR(32));
INSERT INTO #tmp VALUES ('1100'),('9');
SELECT TOP (1) v FROM #tmp ORDER BY v DESC
DROP TABLE #tmp;