Current selection box is not displaying month in proper order

[#1]

Hi All,

I have attached a sample application, It opens with default selection of completed months of current year(2012- Jan, Feb, Mar, Apr, May). Functionality is working properly, but in the current selection box , it displays the month in alphabetic order(Apr, Feb, Jan, Mar, May). How can i fix this? Please provide a solution.

Regards,

Gerard

[swuehl · Accepted solution]

Gerard,

use a sort-weight for the concat function in your OnOpen action, like

='('&concat(DISTINCT {<Month={"<$(=Num(Month(Today())))"}>} Month,'|',MonthKey)&')'

[#3]

Hi,

Thanks the expression is working and it is perfect.

Regards,

Gerard