I am writing a query in which the infoset includes dates example would be material, plant, date, price. For a given material and plant, there will be multiple records in the infoset because the material can have a different price on a different date.
I want to choose the one record from the infoset that has a date closest to but less than or equal to a user entered date.
How do I do this.
Steven Engel