Use First Letter of Month Name in List Box

[prees959]

Hi,

To save space on screen I would like to abbreviate Apr, May, Jun. Jul etc as A. M, J, J when I try to put these into a list box they naturally are condensed to their distinct values..... A,D,F,J,M,N,O,S....   is there a way to get this so the ListBox reads A,M,J,J,A,S,O,N,D,J,F ??

Many thanks,

Phil

[sunny_talwar]

Try this

Dual(Letter, MonthNum)

[prees959]

Hi,

Is this in the load script?

[sunny_talwar · Accepted solution]

load or directly in the list box...

[prees959]

Thanks!  One Last thing, How can I get it to Sort in Fin  Month order?

[sunny_talwar]

What is your Fin Month Order?

May be you can just use Pick Match function. Let say your Month Start with April

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

[prees959]

Sort Is working thanks!  Is there any to keep the Month static in the list box when it is selected rather than it moving to the top?:

[sunny_talwar]

If you used a sort expression, then wrap it around with Only({1} .....)