After using ToString, formula tool won't recognize the field as a string

[rileyspo42]

I've seen this issue on a handful of workflows in the past, all the upstream tools show the Basis Date field as a V_WString but when attempting to perform a string function, the tool says it can't because the field is an integer. Anyone seen this before?

[binuacs · Accepted solution]

@rileyspo42 use Right function instead of TrimRight() function, 

In Alteryx, the TrimRight function removes specified characters from the end (right side) of a string. Its syntax is:

TrimRight(String, y)

• String: The input string to be trimmed.
• y: The character(s) to remove from the end of the string. If not specified, it defaults to removing whitespace.

[Yogesh1795]

@rileyspo42 you can use a select tool to change datatype of basic correct to v_string, or you can use Tostring function in formula tool