Convert Integer to Text
Is there a function that will convert an integer into text? I am in SC21, and using the year function to extract the year from a date. The value that is returned is an integer. ls there a way to convert that integer into a text value? Please advise. Thank you.
Resolved with the following: fn.YEAR(fn.CURRENTDATE())
Not sure if previously using the right syntax or if there was an issue with the destination field format, but the above seemed to resolve the issue.
If you would like to submit an answer or comment, please sign in to the eOne portal.