AnsweredAssumed Answered

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

Question asked by ChrisShepardson on Nov 12, 2010
Latest reply on Nov 12, 2010 by 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. 

Outcomes