6 Replies Latest reply: Oct 9, 2013 5:28 AM by James Lott RSS

    How to create quarter like this : Q1 = March, April & may

      I would like to create quarter with differents months like this :
      Q1 = March, April & may
      Q2= June, july & August
      Q3 = Sept, oct, & november
      Q4 = december, january & february
      I know theses functions :
      'Q' & Ceil(Month(date_calendrier)/3) AS Trimestre_Calendrier
      QuarterName (date_calendrier) as Trimestre_Année_calendrier
      QuarterStart (date_calendrier) as Début_Trimestre_Calendrier,  
      But I don't know how to adapt it in order to make the quarters I wantp>
      Someone could help me?