Forum Discussion

PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago

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

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 val...
Pipelines
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
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
------------------------------
PaulPeterson1's avatar
PaulPeterson1
Qrew Assistant Captain
4 years ago
There is no way to compare a field there, but now that you mention that idea, I could create a formula checkbox to see if the date is yesterday.  and now that I think of it, I can't set the date to the next day like I am currently because that would set change the dates from Friday to Saturday.  I'll need to change the dates to the next business day....sorry, just thinking out loud.  Thanks for stirring my thoughts in the right direction!

------------------------------
Paul Peterson
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    4 years ago
    I'm pretty sure you can drag a field into that box. But it sounds like you are back on track now.

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • PaulPeterson1's avatar
      PaulPeterson1
      Qrew Assistant Captain
      4 years ago
      As it turned out, it was easier to create a formula checkbox.  That way I could roll all of the conditions into 1 field and only needed 1 condition.  Sometimes brute force is the simplest solution ; )

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