1 Reply Latest reply: Dec 26, 2012 12:30 AM by Kabilan Kumarasamy RSS

    how to get previous Quarter

      I used the following formula to get the quarter selected


      = 'Q' & ceil(Month(max(MonthName))) / 3 &', '& Year((max(MonthName)))


      so when i select a month it give me the quarter as  Q4,1012



      now if i want to get the previos quarter how can i do that. For the month its easy but for quarter no idea at all