Pipeline expression to concatenate and format date

Question

I feel like I am close, but still getting an error on my jinja expression.

I need the pipeline to populate a text field based on the concatenation of 2 fields, 1 of which is a date field which needs to be formatted to text.

Output should be HBL-0000-08-01-2025

HBL-0000 is the b.report_asset_id

08-01-2025 should be the formatted a.new_charge_date

Pipeline shows the following error:

Validation error: Incorrect template "{{[b.report_asset_id + '-' + a.new_charge_date|date_mdy}}": unexpected '}', expected ']'

Mez · Accepted Answer

Easiest way for a text field is to keep the dash outside the expression or quote it inside. {{b.report_asset_id}}-{{a.new_charge_date|date_mdy}}{{b.report_asset_id + "-" + a.new_charge_date|date_mdy}}

EmberKrumwied · Answer

Tried the 1st option and that worked. Thank you.

Sign up

Login to the community