Thanks Mark! I'll research this and give it a shot. Thanks for the quick help!
My Advanced Query continues to return an error:
{{ a.create_date - time.delta(days=1) }}
Validation error: Incorrect template "{{ a.create_date - time.delta(days=1) }}". TypeError: unsupported operand type(s) for -: 'NoneType' and 'relativedelta'
I'm trying to search for Client records that were created yesterday and add those to my upsert.
Qrew LegendI'm not very proficient in Jinja Date Math. You can cheat and make a native Quickbase field and then hook onto that. Also, You have not explained how you plan to use a date/ time field in a fitter in the pipeline.
In native Quickbase you would just have a formula checkbox field
ToDate([Date Created]) = Today() - Days(1)
Def leaning towards the formula checkbox filter at this point LOL. Problem is, in my pipeline, ONLY the advanced filter option is available. I can't even use the simple filter option which is where I would reference the formula checkbox. Perhaps that's not allowed when doing upserts? Still very green at jinja and bulk upserts. I'll keep plugging away at this one. Thanks again.
Qrew LegendWhy not just fire the Pipeline one by one as new records arrive in Table A?
