String Formula Field concatenating Date and String Zeroing out

[aMac]

I have a formula field that says:

"Error Log - " && DateTimeToday()

Field data type is a V_WString [128]

And I am able to successfully get an output for either of those expressions by themselves, but when I attempt to concatenate those values like in the statement above, the Formula field's output is '0'.

What do I need to adjust so that the ouput reads as 'Error Log - yyyy-mm-dd' in the output?

[JohnJPS · Accepted solution]

Hi @aMac,

Try a plus instead of a double ampersand:

"Error Log - " + DateTimeFormat(DateTimeToday(),"%Y-%m-%d")