Motnh Sort

[#1]

Hi All,

I created a list box using the month in my dataset. But how do I sort it? I want the months to be sorted in the order Jan, Feb.. etc.

Please help, thanks in advance!

[swuehl]

Hi,

how have you generated the Month field? Using the Month() function or loading the field from a data source?

[#3 · Accepted solution]

If field format is date then sort by value as usual number.

If string - you should create one more field with month number and sort first field by second field.

UPDATE

By the way -- on your screenshot Month is already sorted. Just in wrong direction.