Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
prees959
Creator II
Creator II

Use First Letter of Month Name in List Box

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

1 Solution

Accepted Solutions
sunny_talwar

load or directly in the list box...

View solution in original post

7 Replies
sunny_talwar

Try this

Dual(Letter, MonthNum)

prees959
Creator II
Creator II
Author

Hi,

Is this in the load script?

sunny_talwar

load or directly in the list box...

prees959
Creator II
Creator II
Author

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
Creator II
Creator II
Author

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} .....)