2 Replies Latest reply: Nov 21, 2012 1:33 AM by Leni Balakrishnan RSS

    Split set of Dates based on the input value

    Leni Balakrishnan

      Hi,

       

      My scenario is

       

      In my table I have two fields Date and Amount.

       

      I need to split the set of dates based on the given input.

       

      Like,

       

      If I gave input as 10, then it should split dates in 10. From 01-09-2012 to 10-09-2012, 11 to 20 and so on and the sum of amount to be calculated for the date frame.

       

      For Example,

      Date                               Amount

      01-09-2012                          10

      02-09-2012                          10   

      03-09-2012                          10

      04-09-2012                          20

      05-09-2012                          20   

      06-09-2012                          20

       

      Input value = 3

      output:

      DateFrame                            Amount

      01-09-2012 - 03-09-2012          30

      04-09-2012 - 06-09-2012          60

       

      Thanks in Advance.

       

      Regards,

      Leni