BradElmoreQrew Assistant Captain10 months agoHelp 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])...Show More
BradElmoreQrew Assistant Captain10 months agoGot it working! needed to switch the OAF & OBF------------------------------Brad Elmore------------------------------
Related Contentadvanced query in a pipelineSize(GetRecords Formula QueryMultiple reference proxy fields helpFormula Query for null datesFormula URL - Edit then Add
Recent DiscussionsFilter Monthly, Quarterly, Yearly from one Date fieldExtrapolating nuanced dataSolvedForms helpShare your feedback on the new Qrew DiscussionsGenerating QR Code with URL to record