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.

       

      Thanks,

      Neil