2 Replies Latest reply: Oct 17, 2013 5:03 AM by Caroline Roarty RSS

    Custom Sort in List Box

      Hiya, I have some text fields denoting Periods in my data set. These are labels as follows:

      Pre-Project

      Q1 2012

      Q2 2012

      Q3 2012

      Q4 2012

      Q1 2013

       

      I would like to custom sort them to they are in above order - but at present they won't do this (and either just go in load order or Q1 2012, Q1 2013 etc). Is there an expression I can use to sort these?

       

      thanks