Displaying two linked records + date in one cell;

[JWHW]

Trying to get the “)” to display after the “X” in COMX

(({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} results in:

2200-KLO-KLO (COMX

but

(({SchDep} & “-”) & {Dest} & “-”) & {LdTo} & " (" & {SCAC} & “)”)

results in a formula error.

I’m also unable to display the date from a date field as part of the formula. It ends up looking like 2019-17-26-T00:00:00.000Z

Also, is it possible to formulate two linked records {A} and {B} to display in one cell with the above?

[Kamille_Parks · Accepted solution]

Your formula has unnecessary parentheses.

DATETIME_FORMAT({Date},'YYYY-MM-DD') & ' ' & {SchDep} & '-' & {Dest} & '-' & {LdTo} & ' (' & {SCAC} & ')'

To get a date to appear ‘properly’ you need the DATETIME_FORMAT() function, i.e. DATETIME_FORMAT({Date},'YYYY-MM-DD'), which would display today’s date as 2019-07-29

[JWHW]

Wow thanks again, Kamille! You got skills!