order by in select statement sql server

Viewed 48

I try to fetch date from table in descending order but when i write order by clause in query this shows date in ascending order .. i can not post whole query i post specific line e.g. order by .. when i tried this is what query shows

 date
    01/03/2016
    26/02/2016
    25/02/2016
    06/01/2015

but this is what i want in re

 date
    06/01/2015
   25/02/2016
    26/02/2016
    01/03/2016

this is what i tried

 ORDER BY
convert(date, account.postdate) DESC,      
account.ACDOCNO ASC     

any solution?

3 Answers
Related