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)
[email protected]
------------------------------
QuickBaseJunkie's avatar
QuickBaseJunkie
Icon for Qrew Legend rankQrew Legend
4 years ago
Paul, it looks like you found your solution.

Here's the Jinja info for anyone looking to take that approach.

Get the Jinja Date & Time Cheat Sheet mentioned in this video.



------------------------------
Quick Base Junkie
------------------------------