How do I use Today() in a Pipeline Query line?

Question

I have a pipeline that I need to run every morning and based on several conditions update a set of data. One of the data points is the Effective Date.

I don't have the option to drag the value from a field and I need the condition to look at all records from the previous day (the pipeline is scheduled to run at 1:00 AM each morning). The only options I see in the highlighted field is using the calendar and I don't have an option for "today".

------------------------------
Paul Peterson
------------------------------

MarkShnierYou · Answer

There might be a fancier way using Jinja, but a low tech solution is to create any date formula fields you need in native QuickBase in that same table and then you will have a field to compare to.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community