10 Replies Latest reply: Nov 6, 2015 4:18 AM by William Choo RSS

    How to create a custome MidYear(jan-may) YearEnd(Jun-Nov) Group?

    Jim Chan

      Hi there.


      if i want a Quarter - i know can be written this way


      'Q' & ceil(month(TempDate) / 3) as Quarter.


      But my client wants a MidYear(jan-may) and YearEnd(Jun-Nov) group.