18 Replies Latest reply: Nov 28, 2013 4:37 AM by Sokkorn Cheav RSS

    2 digit year field how to sort from hi to lo ?

      Hi All



      I am using below code to get 2 digit for year :-



        Right(year(date),2)           as [year_],



      I am not able to sort the year in sequences from hi to lo



      Any work around ?