AnsweredAssumed Answered

Date Range Value Lookup

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

Title

Date Range Value Lookup

Post

     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

     Mark

      

Outcomes