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