0 Replies Latest reply on Jan 24, 2012 10:50 PM by Abdus Saboor Ahmad

    Sort the Date Ascending and Descending Order in the WorkSheet

    Abdus Saboor Ahmad

      Hi,

      i want to ask about the Date Ascending and descending order means

      using Columns names in 1 parameter and ascending/descending options in 2nd parameter after that create a calculated field in which is like

      Case [sort by column name]

      when "A1"then

      if [sort order by]=" ascending" then Sum(MONTH(DATE("1 "+[Month]))*10000+YEAR(DATE("1 "+[Month])) ) else -Sum(MONTH(DATE("1 "+[Month]))*10000+YEAR(DATE("1 "+[Month]))) End

       

      END

      ....

      Ascend as

      jan 1,2011

      ::::

      ::::

      dec 31,2010

      whereas descend as

      dec 21,2010

      :::::

      jan 01,2011

      ....

      any solutions as above not working not sort Month,day,year wise sorting on the Month,Day,Period of Calendar,

      reply me @ asa.i060436@gmail.com as well