Skip to main content
Question

Help with Formula Query Field with multiple Dates

  • July 28, 2023
  • 0 replies
  • 138 views

Forum|alt.badge.img+8

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+8
  • Author
  • Quickbase Alumni
  • July 28, 2023

Got it working! needed to switch the OAF & OBF



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