Forum Discussion

JosephMahon's avatar
JosephMahon
Qrew Cadet
2 years ago

Pipelines Date/Time Jinja Date is Between Two Dates-Send Auto

I am trying to search for when a date/time field will fall between essentially a 24 hour window starting from when the pipeline is triggered (likely hourly but potentially 3 different pipelines with 3 different times daily)

Ultimately this is going to trigger a text message through our Twilio connection.

It keeps posting as "No Records Found" and it is killing me! I tested the Jinja in some date/time fields and that part seems to be working.  I don't know why it is saying "No Records Found"

Query:

[Date/Time Filed] is between

{{ time.now|timezone('America/Los_Angeles') }}

{{ time.now|timezone('America/Los_Angeles') -time.delta(hours=24) }}

+

Checkbox Field #1 is yes

Checkbox Field#2 is yes

When I look at the [Date/Time Field] it 100% is between the two times.  

I even tested the Jinja Expression in other fields to make sure it is printing the correct times and it is!

Any and all guidance is appreciated.



------------------------------
Joseph Mahon
------------------------------
  • I fixed my issue with a different solution but would still love to know what wasn't working here.

    My solution was just to create a formula check box that turns on when the above was met and then search the the records for when the check was was true on a daily basis. 



    ------------------------------
    Joseph Mahon
    ------------------------------