Help!
I am trying to populate an ID field with 3 combined fields.
FORUM, ACTION TYPE and IDENTIFIED being the 3 fields I need to combine.
When it populates the field, it adds the time. I want to remove it. The calendar control is set to use a date with no time and displays it correctly in the actual IDENTIFIED field but when it populates the ID field, it adds it in.
Right now the formula looks like this: concat(FORUM, "-", ACTION TYPE, "-", IDENTIFIED).
It displays like this: SEIPT-BUS-2014-01-21T00:00:00
I need it to look like this: SEIPT-BUS-2014-01-21
Thanks in advance for any and all help anyone can provide.
Regards,
Angie