Sort order

[knightwriter]

Hi All,

Ive created a master calendar and from here I have created a list box of my data by week (ie 01/02/16-07/02/16 / W5) but the sort function wont allow me to go:

01/02/16-07/02/16 / W5

08/02/16-15/02/16 / W6

16/02/16-23/02/16 / W7

24/02/16-03/03/16 / W8 etc

any suggestions / expressions on how I can do this?

Thanks.

[sunny_talwar]

What is the expression you used to create this data by week field?

[dmac1971 · Accepted solution]

Try and sort by load order?  Your master calendar normally creates dates in sequential order so I use this to sort my dates into the right order.

[knightwriter]

Hi Sunny,

Sure, you've helped me enough times!

Date(WeekStart(TempDate),'DD/MM/YY') & '-' & date(WeekEnd(TempDate),'DD/MM/YY') & ' / w' & Week(TempDate) as [Created Date]

[knightwriter]

Thank you, I only had one option selected, so used Load Order and State -> Ascending