change the numeric date format to character date format

[sunny8]

hi
I have a column which shows month & year as 01/2011, 02/2011.........and so on
now i need to change this numeric format to character format by applying a date function in the column expression
can any one suggest me what query i can apply for that column to get the req; out put..
i mean the req; output for me is like Jan/2011, feb/2011.......and so on


Thanks in advance

[lucasdnd]

If you have numeric values for Year and Month, I guess you could try this function:

_make_timestamp (x, y, z)
Where x = year, y = month and z = day.

Then, you can set the Data Format for this field to "Date" and format the way it shows on the report.