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.

       

      Rgds,

       

      Jim