I want to compare invoice date to a date range and return price

[ewarr]

Hope someone can help!

I have 2 files linked:

File 1: Invoice records with no prices
File 2: Pricing by invoice date range and state

I want to check the invoice date for each record in File 1 and find the appropriate price in File 2 by comparing invoice date in File 1 with a date range in File 2 and then returning the price if the state matches. Files are linked by state and product. Each record in File 1 must find a match in File 2 on state and date range.

File 1 fields:
Invoice date
Product
Qty
State

File 2 fields:
From Date
To Date
Price
State

Thanks for the help!

 

[lbass]

Add a >= link for invoice date to From Date and a
<= link for invoice date to To Date.

-LB