3 Replies Latest reply: Apr 30, 2013 6:03 PM by Yaniv Egozi RSS

    Dates deployment accurding to payment number

    Yaniv Egozi

      G'day

      I have a sales table that shows

      payment_date, sale_ammount, number_of_payments, first_payment, other_payments

      that I want to break it into actual payments date

      for example:

      payment_date = 28-APR-2013,

      sale_ammount = 1000,

      number_of_payments = 9,

      first_payment = 200,

      other_payments = 100

       

      I want to see it like this

       

      28-APR-2013, 200, 1

      28-MAY-2013, 100, 2

      28-JUN-2013, 100, 3

      28-JUL-2013, 100, 4

      28-AUG-2013, 100, 5

      28-SEP-2013, 100, 6

      28-OCT-2013, 100, 7

      28-NOV-2013, 100, 8

      28-DEC-2013, 100, 9

       

      What is the best way to do it?

       

      Thanks in advance.

      Yaniv