3 Replies Latest reply: Nov 7, 2016 12:03 PM by Tresesco B RSS

    Generating quarters

    Mindaugas Bacius

      Hello,

       

      I have a table like this:

      IDStartEnd
      12016-05-01
      22016-08-012017-01-31
      32016-04-012016-09-31

       

      The idea is to generate the quarter intervals in between Start and End dates.

      If field End is empty then the End should be the closest end of the quarter made from Start and Today() dates.

       

      The result should be like this:

      IDStartEnd
      12016-05-012016-07-31
      12016-08-012016-10-31
      12016-11-012017-01-31
      22016-08-012016-10-31
      22016-11-012017-01-31
      32016-04-012016-06-30
      32016-07-012016-09-31

       

      Thank you!