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

quickbasejunkie · Answer

Paul, it looks like you found your solution.Here's the Jinja info for anyone looking to take that approach.Get the Jinja Date &amp; Time Cheat Sheet&nbsp;mentioned in this video.
------------------------------Quick Base Junkie------------------------------

quickbasejunkie · Answer

Hi @Brittany ZaneThanks for posting this. It appears the behavior in Step A with regards to dates has changed. I previously used and tested the code that you are using and now I too am getting the validation error.​I have not yet found a proper workaround. It looks as though the Pipeline wants a format similar to "2022-04-18T00:00:00+00:00"&nbsp; even if it is just a Date field.I will post an update when/if I'm able to resolve this with Jinja.In the meantime I would suggest using an Advanced Query instead as it is simple to use 'today' in the query such as:{7.EX.'1'}AND{8.EX.'today'}Where 7 would be replaced with the field ID for your Proposal Log - Deposit Required field and 8 would be replaced with the field ID for Fiscal Year End.Please note you will need to delete all of the Queries you have Step A now, in order to access the Advanced Query (just above the existing Queries).For more on Queries: https://www.quickbasejunkie.com/blog/query-writing-101------------------------------Quick Base Junkie------------------------------

brittanyscheid · Answer

Thanks for the reply. I did find that Advanced Query workaround through another post and have been using that for now. I too was confused because I was sure I had it working in a pipeline previously as well, but over the last couple weeks/month, I haven't been able to get it to work. Please let me know if you find a solution. Thanks!------------------------------Brittany Zane------------------------------

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

paulpeterson1 · Answer

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

Forum Discussion

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