Sorting a month list box

[#1]

I created  a "month" field from a key, in my script, using the make date feature.  When I created the list box to show the months (01, 02, 03, etc) I used an expression to show the months as Jan, Feb, Mar, etc.  Now, the list box sorts correctly when I use the sort by expression, = Month expression.  When users are accessing the document (via accesspoint) the sorting is all mixed up. 

When I re-sort the qvw file it seems to fix it, but only temporarily.

Anyone else experience this problem, or know how I can solve this issue?

[deepakk · Accepted solution]

hi,

Instead of doint it in expression do it at script level and bring it as a field.

Deepak

[#3]

Hi Mike,

In the sort expression use Only function with a set analysis and ignore the selections users are making.

which helps you to remain the sort order same.

hope this helps

thank you

Meher

[#4]

suggest you create a calendar master data....or at least a field of MMM YYYY, so when you need 2011 June to 2012 June, it will be sorted properly... just use date(date, 'MMMYYYY')