Help

Displaying two linked records + date in one cell;

Topic Labels: Formulas
Solved
Jump to Solution
1511 2
cancel
Showing results for 
Search instead for 
Did you mean: 
JWHW
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

Capture.PNG

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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

See Solution in Thread

2 Replies 2
Kamille_Parks
16 - Uranus
16 - Uranus

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

Wow thanks again, Kamille! You got skills!