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

Question

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?

binu_acs · Accepted Answer

@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.