3 Replies Latest reply: Apr 21, 2015 9:27 AM by Shiva Reddy RSS

    First Quarter (Q1) begins with April

    Paul Steinborn

      Dear Community,

       

      i am generating quarters on my dates and tried these solutions:

       

      'Q'&If(Month(QuarterStart(DATE))='1',4,Div(Month(QuarterStart(DATE)),3)) as DATE_QUARTER;

      or

      if(len(DATE)>0, 'Q' & ceil(month(DATE)/3),ceil(month(DATE)/3)) as DATE_QUARTER;

       

      Unfortunately the first quarter (Q1) begins all the time with April.

      It should begin with January! How can i achieve this?

       

      Please help