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

Hi @Brittany Zane

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

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