6 Replies Latest reply: Jul 15, 2016 11:16 AM by Haritej Kambhampati RSS

    Last but One Date/Price based on Condition

    Haritej Kambhampati

      Hello Guys,

       

      I am trying to find out the most recent price changes on Materials. Here is what I have in the table

       

      Material      Valid From Date   Valid To Date    Price

      123               01/01/2012          01/06/2012        10

      123               01/07/2012          05/12/2013         20

      123               06/12/2013          12/31/9999         30

       

      As shown above, the Valid to date of the Last change is always set to 12/31/9999 which helps me get the price changed to (30 In this case). I am not sure how to the the price before last change (20 in this case).

       

      Appreciate your help

       

      Thanks

      -Hari