List Box Sorting

[#1]

Hi All,

i have  list box which has date in DEC_13 format , i have dates from DEC_13 to NOV_15. so when i see them in list box they are sorted in ascending order . but when i select any date , the sort order is messing up .

for example when i have list like

DEC_13

JAN_14

FEB_14

MAR_14

But when i click on MAR_14

the order changes to

MAR_14(SELECTED ITEM FIRST)

JAN_14

DEC_13

FEB_14

this is how it is showing in list box,

so kindly any help is appreciated .

Thanks,

Aditya      

[amit_saini]

Hi Aditya,

You can try something like below:

Dual(Month,Match(Month,'jan','feb','mar','apr','may','jun','jul','aug','sep','oct','nov','dec'))

Thanks,

AS

[sasikanth]

HI

try some thing like below in Sort --> Expression tab

wildmatch(only({1}Month_field),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec')

[Anonymous]

Try to uncheck this option..Auto Ascending...

[PradeepReddy]

see the attachment...

[#6]

I have faced exact same issue.

Apply soting as screnshot below

:

[jagan]

Hi,

Uncheck State option in Sort tab of List box properties.

Hope this helps you.

Regards,

jagan.

[avinashelite]

List Box>Properties>Sort>uncheck the sort on the State option

[#9]

Hi All,

Thanks for the input . I am still facing the same problem . i have date field  has Dec_13 ,Jan_14 , these are getting sorted on period_Month_Date(12/1/2013) , which is another field . then i can see the list box values are sorted  .but  when i am giving wildmatch function and also dual ,then clicking some random month for example Mar_15

the result is not even getting sorted and after the click i am not seeing the right sorted values

= wildmatch(only(Period_Date_Format),'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') 

=Dual(Period_Date_Format,Match(Period_Date_Format,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec') )

i am still faicng the same problem

[#10 · Accepted solution]

Hi All,

i got answer from following post

MinString({1} monthfield)

which was in this thread :

Sorting changes when selection is made

thanks anyways