have list box issue

[NavinReddy]

Hi Community,

i have list box issue

I have list box like      Jan ,April,Aug ,Dec,Feb,july,march,nov....

but i need to be arrange  Jan,Feb,March,April,May,June,July....

I tried but Accesding order every thing

Is there any manually arrange

Could some one help me

Thanks in Advance,

Rohith

[hic]

If you create this field using the Month() function, the values will be dual (both text and number) and they will be sorted automatically.

HIC

[Joaquin_Lazaro]

On Properties/Order tab there are different metods to order this, try with an expression or load order

[NavinReddy]

Hi Henric,

now also i got same issue

i didn't get give some example

Thanks,

Niranjan

[#5]

try this

month(date(date#(field,'MMM'),'MMM')) as month

[#6]

suppose your field name in listbix is fieldmonth

in listbox properties-

general tab--> select dropdown in Field--> select expression --> then write this code-

month(date(date#(fieldmonth,'MMM'),'MMM'))

[NavinReddy]

  Inline:

     Load * inline [

     Month, MonthSort

     JAN,1

     FEB,2

     Mar,3

     ..

     ];

     Make sure that the Month field name links with your month field in data model.

     Now go to the listbox properties- > Sort ->Select Expression ->Type MonthSort.

its working fine but if i press Jan it goes some where

it con't Stable at

Thanks,

Rohith

[#8]

Hi,

Goto your list box --> Sort --> Expression (Paste the expression =Date#(Your month field,'MMM')) and have it as asending order.

Regards,

Kabilan K.

[kaushiknsolanki]

Hi,

     Yes, in sort option you will see the first option State, Check that and say Ascending.

Regards,

Kaushik Solanki