4 Replies Latest reply on Nov 12, 2010 12:49 PM by ChrisShepardson

    Using Constrain Found Set [] to show only date closest to Current Date?

    ChrisShepardson

      Title

      Using Constrain Found Set [] to show only date closest to Current Date?

      Post

      I have three fields P/N, Qty, Price, and Date.  Is it possible to use the Constrain Found Set [] script step to show me only records that are closest to todays date, while eliminating duplicate Qty fields.  Something like this:

      P/N  Qty Price  Date

      abc  20  .50 09/09/09

      abc  20  .50 09/20/09

      xyz  30  .99 10/10/10

      abc  40 .25 07/07/07 

      and the Found set is:

      abc 20  .50  09/20/09

      abc 40  .25  07/07/07

      If not how can I do something similar.