I have three fields I want to combine, with separators.
FieldA (text field), example: Bob
FieldB (text field), example: Smith
FieldC (date field), example: 10/28/2020
I would like a calculated field to show the following:
"Bob: Smith, 10/28/2020"
How would be the best way to go about doing this? I've tried combining the fields using + " " + but that didn't work.