Weekday

[#1]

Hi all,

I made the following list box:

Weekday:

mo tu ...... sun

It just works fine it gives me the results I want when i select a day, however when I select Tuesday for instance it puts Tuesday on the beginning or the end of the line:

Tuesday, wednesday thursday friday saturday sunday

or friday:

Friday mo, tue, wed, thu, sa, su

Is there someway to just lock it? Like when i select tuesday it doens't pop to the beginning or the end of the line.

It just keeps in chronological order no matter what day I select.

Moday-Sunday

my script for weekday:

LOAD * INLINE [

    PerformanceWeekday, Sort

    mo, 1

    tu, 2

    we, 3

    th, 4

    fr, 5

    sa, 6

    su, 7

];

kind regards

[alexandros17]

Probably you used an expression in your list box, fix it computing that exprression in the script and use the nuew field. it should work

[#3]

If you go to the properties of your listbox > Sort : deselect the Status option.

This should solve it.

[#4]

In the list box, sort tab

uncheck the sort by state

keep sort by load order

Fabrice

[#5]

if I deselect everything my week isn't in the correct line up

(mo-sun)

however then it does lock and isn't moving when I select a day

[#6 · Accepted solution]

you could try to sort by expresion.

sum(Sort)

or sort by load order

[jpapador]

O the sort tab, uncheck sort by state as others have suggested.  Then in the Expression box (on the sort tab) manually sort them like:

Match(WeekDay, 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun')

make sure to check the expression check box.

[#8]

thanks Jelco!

Thanks for all the suggestions people 😃