4 Replies Latest reply: Sep 4, 2012 11:27 AM by Jonathan Dienst RSS

    Getting the "oldest" Value

    Kristian König

      Hello again,

       

      Another question from me again .

       

      I have a table with Data:

      Buyer number - amount -  Last Day to pay(Date format)

       

      One buyer can have more then one Days to pay. Is there a possibilty to write a script: Give me for every buyer only the oldest Date?

       

      I can import all the data into QV(but its a huge file), but i would like if its possible to import only the oldest Date(with buyer number and amount).

       

      how does the formula/scrpit looks like?

       

      Thank you,

       

      Kristian