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 ?

       

       

      PAul