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