4 Replies Latest reply: May 21, 2018 4:53 AM by scott wang RSS

    How to Sort master item and value

    scott wang

      Hi All,

       

      In Master Item:

      1.jpg

      Two question:

      1.If we can not rename them ,I want to Sort :Year->Month

      2.For Month field, I want to sort from Jan to Dec,not A-Z.

       

      Any idea,thanks.

        • Re: How to Sort master item and value
          bhasker kumar

          Hi,

           

          You can sort Month by using Pick Match Functions(PFB) in Sortby Expresstion under the listbox property and then you can add this to master item.

           

          pick(Match(YourMonthField,'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep','Oct','Nov','Dec'),1,2,3,4,5,6,7,8,9,10,11,12)

          year.PNG

           

          or you can achieve the same thing in backend- master calender using dual function PFB.

          Dual(YourMonthField, YourMonthNumber)

          I,e Dual(CalenderMonth, CMonth)

          where Cmonth is Month(TempDate) as CMonth,

           

          in a same way you can sort the year as well.


          if you found this helpful,  please mark helpful or correct

           

           

          Regards,

          Bhasker Kumar