This discussion is archived
7 Replies Latest reply: Mar 11, 2013 3:21 AM by 976632 RSS

sort problem

976632 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points