String binding




I want to concatenate the strings!

When displaying the time, I want to use "hour" + ":" + "minute"!

Example: "9" + ":" + "15" → 9:15

I'm not good at English, so this may be difficult for you to understand.

Thank you!

Best Answer

  • Vinay VaradarajM

    Hi @KubotaNatsuki ,


    You can achieve this by using & in your expression instead of +, provided all are in text format.

    If you have hour and minute in number format, you need to convert it to text by using text function.


    Therefore, your overall formula should be text(hour)&" : "&text(minute).

    However, it is recommended that you maintain the delimiter in an admin module lineitem, and refer it in your expression. This way you can main consistency, and the performance is not hampered.