Filter pane month sorted alphabetically

[sebHan]

Hey!

I have a problem with my horizontal filter pane is sorted alphabetically on my month variable.

I would like to sort it such that it shows:  Jan | Feb | Mar | and so on

This is how it looks now.

Can anybody help here?

[Digvijay_Singh]

There are various ways to handle it. I use Dual in the script for the month field to be used in the filter to show formatted as month but date type internally e.g. Dual(Date(Monthfield,'MMM'),floor(Monthend(MonthField)))

Once the type is set as date it can be sorted as asc/desc the way desired.

Thanks,