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,