Concatenate static string with date for Insight Automation

[Matthew Contri]

I have an automation trigger within my Insights DB that will update various attributes with different data.

One of the attributes is "Comments", what I want to do is automatically place something like the following in there when the trigger is fired:

"On " + now() + " , an audit flag of Undocumented Asset..."

Where now() is the date the trigger was fired and the output would be "On 20/3/2024, an audit flag of Undocumented Asset..."

What I currently am trying is:

"On ${now()}, tertiary data, not required by CM has been identified as missing" but nothing is happening.

How do I go about doing this?