Forum Discussion

EmilyWise's avatar
EmilyWise
Qrew Member
3 years ago

Called Pipeline Date Fields not Querying

I am trying to create a called pipeline where the pipeline formula takes a date field, and then I am querying to find all the records after that date in a specific table. 

The output from the called table shows the field (q1_start) is in this form:
q1_start:"2022-04-25 00:00:00+00:00"
but when I try to query the table for any records with dates after q1_start, this is the pipeline output:
If I try using jinja to alter it to datetime, it still does not fetch any records.

------------------------------
Emily Wise
------------------------------
  • Are you sure you're pointing pipeline to the right field?  

    In your log there it says:

    field: "week_start"  which has a null value.

    ------------------------------
    Jeff Peterson
    ------------------------------