Sorting by Expression

[kevbrown]

Really easy question I'm sure.

I'm looking to sort Months but using the sort expression however my months are text (and need to remain as text). What is the expression I need to write? Jan 11, Feb 11, Mar 11, Apr 11, May 11, Jun 11 etc

Thanks

[alexandros17]

Try to sort by loading order

[MK_QSL]

Sort Tab

Use Below Expression

=Date#(MONTH,'MMM YY')

[#4]

Properties-->Sort-->Numeric Value-->Ascending