Expression to combine incompatible data types

  • 4Views
  • Last Post 4 weeks ago
0
votes
Michael Macks posted this 4 weeks ago

I need to concatenate name and Date of Birth for one of my fields. I am getting this error:     How can I format this to work?

The data types "DTWSTR" and "DTDBDATE" are incompatible for binary operator "+". The operand types could not be implicitly cast into compatible types for the operation. To perform this operation, one or both operands need to be explicitly cast with a cast operator.

0
votes
Mariia Zaharova posted this 4 weeks ago

Hello Michael!

 

Please try an Expression like this:

[Name] + " " + (DT_WSTR, 10)[Date_of_Birth]

 

Some useful information is available here.

 

Please tell me if this helps.

 

Best regards,

Mariia

Close