Sorting Problem in Week List box

[tulasiram_bitra]

Hi Frnz,

I would like to show Week 1 to Week 53. But it showing Wk53 first after this Normal Week 1 to Week 52.

How to show from week 1 to week 53?

Please let me know. Please find the attached image.

[swuehl]

Have you tried to sort the listbox by text ascending (sort tab in list box properties)?

If this does not work, how have you created the field and what sort options are currently enabled?

[tulasiram_bitra]

Hi Swuehl,

Sorry for late reply.

I have written expression in listbox like  ='Wk- '&Week.

Sort options are Numeric Value -- Ascending

And I tried Sort => Text -- Ascending also.

But I didn't get solution. Please let me know

[sunny_talwar · Accepted solution]

Try sorting using the expression and input =Week in there and see if that works:

[#5]

Hi Ram,

Can you attach the sample application for this ? . We can achieve this using expression under sort tab .