Sorting month field

[Anonymous]

Hi all

Please let me know how can I sort field named 'Month' having values as follows:

Month

Feb

Aug

Jan

May

Nov

July

I want to display values 'Month' field as:

Month

Jan

Feb

May

July

Aug

Nov

Thanks in advance.

Regards,

[shiveshsingh]

and don't forgot to promote month in sort tab

[baarathi]

Go to sort tab, select sort by expression and give num(month(datefield)) and ascending at top

[sasiparupudi1]

try this  as the sort expression

Date#(Month,'MMM')

or

Num(Month(Date#(Month,'MMM')))