Pipeline Advanced Query formula help
Can someone help me with an advanced query for my pipeline. The formula should filter for the following: Date field id 31 is after Date field id 70 and Date field id 31 is before Date field id...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendWe need to know the field names for the record you are sitting on. The matching on the target table is by fid, but what we are matching to on the record is by field name.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
My first step is a search. I am trying to filter the search.
------------------------------
George Bramhall
------------------------------
------------------------------
George Bramhall
------------------------------
------------------------------
George Bramhall
------------------------------- MarkShnier__YouOK, sorry, I misread your question. I was thinking of a formula query. Personally I would just use the search filters with the blue button to set up my filters. I think its called Add Conditions. To generate the query code you can make a report and then on the old style report More button to ask for the query string.
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------You'll need to write an advanced query. The add condition button doesn't have an option to check if a date is equal to another date.
I'm not the best one to help with the syntax, maybe @Quick Base Junkie can chime in with her 2 pennies.
------------------------------
Paul Peterson
------------------------------
