Help with Formula Query Field with multiple Dates

Question

I'm trying to get the formula below to work ---&nbsp;

ToText(GetFieldValues(GetRecords("{24.EX.'"&amp;[PriceKeyA]&amp;"'}AND{9.OAF.'"&amp;[Invoice Date]&amp;"'}AND{10.OBF.'"&amp;[Invoice Date]&amp;"'}", [_DBID_PRICE_TABLE]), 3))

(Table A)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (Table B)
*[PriceKeyA]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*[Start Date] - fid = 9
*[Invoice Date]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*[End Date] - fid = 10
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*[PriceKeyB] - fid = 24
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;*[Record ID] - fid = 3
I want to populate my [formula text field] in (Table A) --- with the [Record ID] from (Table B) -- when [PriceKeyB] (fid 24) = [PriceKeyA] AND [Start Date] (fid 9) &gt;=/OAF [Invoice Date] &nbsp;AND [End Date] (fid 10) &lt;=/OBF [Invoice Date]

Any advice? Thank you
------------------------------Brad Elmore------------------------------

bradelmore · Answer

Got it working! needed to switch the OAF &amp; OBF------------------------------Brad Elmore------------------------------

Forum Discussion

Help with Formula Query Field with multiple Dates