cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! X

How to use concat function for concatenates string and field?

vbabu-4
4-Participant

How to use concat function for concatenates string and field?

I am getting syntax error in computation express?

1. Concat(ToText("Major Version"),., ToText("Minor Version"),., ToText("Build Number"))

2. Concat(ToText("Major Version"),".", ToText("Minor Version"),".", ToText("Build Number"))


where

Major Version, Minor Version, Build Number are Integer fields

1 REPLY 1
jhampson
4-Participant
(To:vbabu-4)

 

You need to use the Text() function around strings. Strings by themselves are interpreted as field names and you don't have a field called "."

 

For example:

concat(text("Copyright "),ToText(getYear(now())),text(" My Company Ltd.."))

Top Tags