3 Replies Latest reply: Feb 6, 2014 9:21 AM by Gysbert Wassenaar RSS

    Apply relevant data after an effective date

      Hello,

       

      In my qvd I have various fields such as Date and Unit so what I want to do is to apply the below costs (from a spreadsheet) based on the date in the qvd, e.g. For Unit A on 08/08/2013 the Cost is 10 but for Unit A on 23/11/2013

       

      My spreadsheet looks like the below:

       

       

      UnitStart DateEnd DateCost
      A20/02/201309/10/201310
      B19/05/201320/09/201311
      C20/04/201325/04/201312
      A10/10/201323
      B01/10/201325
      C26/04/201326


      Also when there is no end date the cost is active, I.e should be applied to the current data

       

      Thanks,

       

      Ralph