7 Replies Latest reply: Mar 11, 2013 5:21 AM by 976632 RSS

    sort problem

    976632
      Hi

      i have periodname column these values are like

      jan-11,feb-11,mar-11,apr-11,may-11,.......

      it is in varchar format

      i want to use this as prompt in dashboard

      like this aug-11>=periodname

      then it gives all the periods upto aug-11

      but it gives the wrong values ,values are based on the alphabetic order

      in rpd im using sort by startdate on periodname then the values shown correct order but dashboard prompt and filter are giving values based on alphabetic

      please any body help in this


      thanks