Strings and Integers in a Pipeline Date Calculations

Question

I am trying to formulaically change a date with a PipelineIf I hard code the change in the date it will work with the following expression{{a.date +time.delta(days=2)}}However if I use a variable&nbsp;{{a.date +time.delta(days='a.numeric_field')}}I get the errorValidation error: Incorrect template "{{a.date +time.delta(days='a.numeric_field')}}". TypeError: cannot concatenate 'str' and 'int' objects&nbsp;The field a.date is the string and a.numeric_field is my integerI have tried all sort of variations to convert the data type such as&nbsp;
'a.numeric_field|str'
Str(a.numeric_field)
However my syntax is aways wrong.Any suggestions would be greatly appreciated.------------------------------Don Larson------------------------------

doughenning1 · Accepted Answer

Hi Don, you need to specify the field without the quotes:

{{a.date +time.delta(days=a.numeric_field)}}

If a.date is a string and not a date, then you need to parse it:

{{time.parse(a.date) +time.delta(days=a.numeric_field)}}

Hope that helps!

------------------------------
Doug Henning
------------------------------

Forum Discussion

Strings and Integers in a Pipeline Date Calculations