1 Reply Latest reply: Oct 3, 2011 12:29 PM by Rob Wunderlich RSS

    Obtaining closest date in the past for a given date

      Hey,

       

      I have Master table with Article, Date and Price [Prices].

      On the other hand, I have a table with Article an Date [Transaction]

       

      What I want to do is to get the last known price and date from [Prices] for each article where a [Prices].Date <= [Transaction].Date.

       

      Can anyone help?

       

      Solution will be welcome to solve this in an expression but also with scripting.

       

      Thanks