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
My first step is a search. I am trying to filter the search.
------------------------------
George Bramhall
------------------------------
------------------------------
George Bramhall
------------------------------
------------------------------
George Bramhall
------------------------------
- MarkShnier__You
Qrew Legend
OK, 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
------------------------------- MarkShnier__You... I also love Ms Junkie too, but you can also just create a temporary report and cheat the code off the "More button".
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
