Pipeline Advanced Query formula help

Question

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 71 and

Date field id 20 equals Date field id 39.

I can't find any good examples of how to write this filter formula for my pipeline.

Thanks

------------------------------
George Bramhall
------------------------------

markshnier__you · Answer

We 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
------------------------------

georgebramhall2 · Answer

My first step is a search. I am trying to filter the search.------------------------------George Bramhall------------------------------

georgebramhall2 · Answer

field names with Field ID included.------------------------------George Bramhall------------------------------

markshnier__you · Answer

OK, sorry, I misread your question.&nbsp; I was thinking of a formula query.&nbsp; Personally I would just use the search filters with the blue button to set up my filters.&nbsp; I think its called Add Conditions.&nbsp; 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------------------------------

paulpeterson1 · Answer

You'll need to write an advanced query.&nbsp; 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------------------------------

Forum Discussion

Pipeline Advanced Query formula help

10 Replies