List Box 'Month' Picker.... Hel

[prees959]

Hi, 

I currently have a horizontal Month picker :

Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb

Is there anyway to set the list box to use the 'Month Initial' and keep the sort order of March - April , eg:

M | A | M | J | J | A | S | O | N | D | J | F  ?

Thanks,

Phil

[sunny_talwar · Accepted solution]

May be try this as your expression

Dual(Left(Month, 1), Month)

and sort using the following expression

Pick(Month, 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)

[prees959]

Thanks!!! 
Perfect!

[sunny_talwar]

Actually change the sort expression to this

Pick(Only({1} Month), 11, 12, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10)