AnsweredAssumed Answered

Date Range Value Lookup

Question asked by MarkMartin_1 on Jan 14, 2014
Latest reply on Jan 15, 2014 by MarkMartin_1


Date Range Value Lookup


     I need to create script that will look up a price based on the date it was sold.


     I have 2 tables with a relationship between the 2 ProdID fields

     Product table:ProdID, Description and Image fields

     Price table: ProdID, PriceDateStart, PriceDateEnd and ProdPrice fields


     Hope this makes sense