2 Replies Latest reply: Oct 1, 2015 11:48 AM by Digvijay Singh RSS

    Creating date from / date to based on a single date

    Michael Yachnik

      Hi, All

      I have some data with a balance account per day:

      Account NoCurrencyAggrement NoDate of balanceBalance
      0060210000USD000000240000031.12.201317 000
      0060210000USD000000240000001.01.201417 000
      0060210000USD000000240000002.01.201418 000
      0060210000USD000000240000003.01.201418 000
      0060210000USD000000240000004.01.201418 000
      0060210000USD000000240000005.01.201419 000
      0060210000USD000000240000006.01.201420 000

       

      My task leave only first rows (by Account No, Currency, Aggrement No, Date of balance), where the balance has changed:

      Account NoCurrencyAggrement NoDate of balanceBalance
      0060210000USD000000240000031.12.201317 000
      0060210000USD000000240000002.01.201418 000
      0060210000USD000000240000005.01.201419 000
      0060210000USD000000240000006.01.201420 000


      Any ideas?

      Next step I use