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.