How to convert an integer to a string?

[#1]

Hi,

I would like to know how to convert a integer to a string so I can concatenate it (with &) to another string.

More practically, I have a field date coming from my database and from a value of that field, I would like to get "Year-Month".

So:

Month(date) -> Oct (as string)

Year(date) -> 2010 (as integer)

How do I get: "2010-Oct"?

Thank you all

[sathishkumar_go · Accepted solution]

Hi,

use year(date)&'-'&Month(date)

-Sathish