Calculate a future date in a pipeline

Hello Julie,

An easy thing to miss is that in Jinja (which Pipeline uses) when you are doing calculations like that, they should be within the same curly brackets. This is very different than how Quickbase functions work.

For example:

if a.value = 5
b.value = 2

{{a.value + b.value}} comes out to 7

If you put in {{a.value}} + {{b.value}}  it will print the literal text of "5 + 2"

This is why you are getting that error, instead of a time stamp, it is returning the text: "2021-07-13 00:00:00+00:00+ Days(14.0)"

Specific to your use case, I would recommend the following:

{{a.complete_date + time.delta(days=b.maintenance_interval)}}

Information on how to work with dates in Pipelines can be found here: https://help.quickbase.com/pipelines/working_w_date_time.html

I hope this helps!

-Robert Henderson
Support Integration Engineer for Quickbase