Skip to content
+1-888-319-3663

COMMUNITY FORUM

Convert Integer to Text

Jose asked 12 months ago

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.

 

Jose

Jose replied 12 months ago

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.