Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.
In the list box properties, you can also try a sort by expression:
=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')
It would be best to correct this in the script, by parsing in your periods as dates. dates have a numeric representation which you can use for sorting.
In the list box properties, you can also try a sort by expression:
=match( [Pre-Project], 'Q1 2012','Q2 2012','Q3 2012','Q4 2012','Q1 2013')
Brilliant that expression has resolved it! Thanks a lot for your help.