Skip to main content

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?


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

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!

Reply


Terms & Conditions