3 Replies Latest reply: Dec 20, 2011 7:27 AM by Nicosa-Oracle RSS

    need help with thw looping logic

    879804
      If inputcol1 = 'T', then substract 3 to the month of date1 until the result will be '1' or '2' or '3'
      If inputcol1 = 'S', then substract 6 to the month of date1 until the result will be '1' or '2' or '3'

      we have to subtract 3 or 6 with the month part of the date as many times until the result equals '1' or '2' or '3'.

      any suggestions please .