2 Replies Latest reply: Nov 7, 2012 8:34 AM by Vegar Lie Arntsen RSS

    Changing order of months

    Neil Gulliver

      I have a table in which I would like to show months running from July to June instead of January to December.

      I have tried


      if(Month < 7, Month + 6, Month - 5)


      but this seems to convert the months to numbers (e.g. January = 1) and I wish to retain the month as a word.


      Is there another way ?


      What makes this more complex is that the month field is part of a cycle group.