5 Replies Latest reply: Jan 21, 2015 5:50 AM by balkumar chandel RSS

    Sorting by week number

    Tumelo Stewart

      Hi All

       

      I have a listbox which shows me the Weekstart date - Weekend date and the Week number.

      Script:

      Dual(num(if( month(WeekStart( RE_DAY) )<> month(RE_DAY), 1 , day(WeekStart( RE_DAY) )),'00')

         &' - '&

         Num(if( month(WeekEnd(RE_DAY))<> month(RE_DAY), day(RE_DAY) , day(WeekEnd( RE_DAY) )),'00'),

         If(month(WeekStart( RE_DAY) )<> month( RE_DAY), 1 , day(WeekStart( RE_DAY) ))) &' Week '& Week(RE_DAY)as Weeks

      2015-01-20_15-50-08.png

      I would like to sort this by Week from smallest to largest e.g

      Week 2

      Week 3

      Week 5

       

      How can I do this cause the listbox sort propeties is not helping?