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

We are aware of an issue causing intermittent login problems for some users following a recent update. Learn More

Translate the entire conversation x

How to use concat function for concatenates string and field?

vbabu-4
10-Marble

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

 

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.."))

Announcements


Top Tags