Showing month in list box

[#1]

Hi

I am extracting the month name from a column using the substr(to_char(MY_DATE), 4, 3)  as MONTH. I am able to do it successfully. Now I am getting a problem where my listbox doesnt show the month in the order of Jan-Dec.

I have attached the listbox image.

Any suggestions ??

[sreenivas]

Goto Sort Tab Add in the Expression

Wildmatch(substr(to_char(MY_DATE), 4, 3),'Jan','Feb','Mar','Apr','May','Jun','Jul','Sep','Oct','Nov','Dec')

[sivarajs]

Try sorting the text to A-Z