8 Replies Latest reply: May 25, 2017 2:19 AM by Arpit Kharkia RSS

    How can I get the next Quarter from a selected date? Need to use it for Set Analysis to get Orders for selected date Quarter and it's next Quarter

    John Blomqvist

      Hi there,


      I have a Date field called OrderDate.


      From this OrderDate I dervice which Quarter a particular date is in.


      What I would like to do is get the next Quarter from a selected OrderDate.


      Currently I calculate a Quarter field in the script using 'Q' & CEIL(MONTH(TempDate) / 3) AS Quarter as part of standard master calendar.


      Any idea how to get the next quarter?


      Ultimately I want to use this in Set Analysis where I can show me Orders for this quarter and next quarter.