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
QuickBaseJunkie's avatar
QuickBaseJunkie
Qrew Commander
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
------------------------------
BrittanyScheid's avatar
BrittanyScheid
Qrew Cadet
3 years ago
I have been trying to use this for entering in today's date (EST) into date fields several times now in different pipelines, and I keep getting the below error. I made sure to copy and paste the formulas directly from the cheat sheet, but no luck. Any help would be greatly appreciated!

------------------------------
Brittany Zane
------------------------------
  • QuickBaseJunkie's avatar
    QuickBaseJunkie
    Qrew Commander
    3 years ago
    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
    ------------------------------
    • BrittanyScheid's avatar
      BrittanyScheid
      Qrew Cadet
      3 years ago
      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
      ------------------------------
      • QuickBaseJunkie's avatar
        QuickBaseJunkie
        Qrew Commander
        3 years ago

        @Brittany Zane I figured it out, although it's not the answer either of us will like.

        Basically, Jinja such as this
        {{ (time.now|timezone('America/Los_Angeles')).date() }}​

        Can only be used on "Search/Query" type steps when in Step A.

        I do have a footnote to this effect on the Jinja Date/Time Cheat Sheet (but it's easy to miss or forget about).


        The messaging from the Pipeline error is very misleading as it appears its just the wrong format when in reality it's not reading it at all. (I invite the Pipeline developers to correct me if I'm wrong).

        Besides the Advanced Query solution, the other option if your Step A is a Trigger or Action would be to insert a Condition just after the step such as this.

        The background shows the condition, the foreground shows the activity success.





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