5 Replies Latest reply: May 5, 2015 5:12 AM by Hasvine Dhurmea RSS

    Sorting of month.year

      Hello Everyone,


      Can someone urgently help me in resolving this issue:


      I have created my 'month.year' field in my script using the below line:



      month(subfield([date], ' ' ,1)) &' '& Year(subfield([date], ' ' ,1)) as monthyear,


      and it works perfectly.


      However, when i create a bar chart with it, I do not manage to sort the date correctly.sort fail.PNG


      I tried to sort it in all possible ways in the ''Chart Properties tab Sort'' but nothing works.