Forum Discussion

BradElmore's avatar
BradElmore
Qrew Assistant Captain
10 months ago

Help with Formula Query Field with multiple Dates

I'm trying to get the formula below to work --- 

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

(Table A)                                (Table B)

*[PriceKeyA]                             *[Start Date] - fid = 9

*[Invoice Date]                         *[End Date] - fid = 10

                                                 *[PriceKeyB] - fid = 24

                                                 *[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) >=/OAF [Invoice Date]  AND [End Date] (fid 10) <=/OBF [Invoice Date]

Any advice? Thank you



------------------------------
Brad Elmore
------------------------------

1 Reply

  • BradElmore's avatar
    BradElmore
    Qrew Assistant Captain

    Got it working! needed to switch the OAF & OBF



    ------------------------------
    Brad Elmore
    ------------------------------