Problems with sorting data

[kterrill]

I have added a dataset to Wix describing lessons. I want to sort the lessons by year and then by lesson number. Everything sorts properly, except for two entries. I have the same problem on the page where I display an index for the collection. I have sorted the collection first by year, then by lesson number. The same two items display out of order. Could someone please help me figure out how to fix this? Thank you in advance for your help.

[CODE-NINJA]

Hallo kterrill ,

perhaps the sorting would work, if you would use something like…

01
02
03
04
.
.
.
.99

instead of

1
2
3
4
.
.
.99
Try it out.

[kterrill]

Thank you for the suggestion. I have tried adding zeros before the single digit numbers, but Wix automatically deletes them.