Formula with Strings, Datetime and Fixed decimal

[Hi2023]

Hi 

help plz.

I am appending 3 items in one formula tool but when I get to the last one it doesnt like it

VWstring + Datetime + Fixeddecimal

[MitchellBliesner]

Hey, are you able to share a workflow so I can see the error messages and play around with it?

[MitchellBliesner · Accepted solution]

If I had to guess though I would say that the data types are not the same so I would do (VWstring) + ToString(Datetime) + ToString(Fixeddecimal) because it can't concatenate a string and a decimal and a date. Let me know if this helps. 

[acarter881]

Hello, @Hi2023.

I believe the only functions required to solve this may be in DateTime Functions and Conversion Functions.

As an example, if you have a number and you want to concatenate it with a string then you can use ToString([Some Number]) + 'Your String' and the Formula tool will work as intended (assuming the data type for the field is a string).