Concatenate two fields

[Kuroshi]

Hi.

I need a Formula to combine two fields. Here's the formula that I'm using:
CONVERT(VARCHAR, [@field:FieldA]) + ' '  + COVERT(VARCHAR,Year[@field:DateField]).

 I am trying to write a formula that will pull the year out of the date in this field. I am getting an Invalid Formula. Can you help?

[Barbie]

Hi,

You can use the formula below to concatenate these two:

CONVERT(VARCHAR(10), [@field:FieldA], 101) + ' ' + CONVERT(VARCHAR(10), (DatePart(year,[@field:DateField])), 101)

I converted these fields to text so that they can concatenate as two different fields instead of having a sum as a result.

- Barbie

[Barbie]

Hi,

Just to add, you can also check more information here: https://stackoverflow.com/questions/3715675/how-to-convert-float-to-varchar-in-sql-server
https://howto.caspio.com/function-reference/

 

[SinJunYoung]

On 11/30/2020 at 1:16 PM, Barbie said:

Hi,

Just to add, you can also check more information here: https://stackoverflow.com/questions/3715675/how-to-convert-float-to-varchar-in-sql-server
https://howto.caspio.com/function-reference/

 

Thanks @Barbie! U are an angel

[TellMeWhy]

I'm also adding information to Barbie's answer, to know more about what the 101 means in the code, you may refer to this link, It's for datetime format https://www.mssqltips.com/sqlservertip/1145/date-and-time-conversions-using-sql-server/