Date Format

[upaliwije]

='Premium ' & (Max(R_YEAR)) &'-'& (Max(R_MONTH))

when I use above label in a chart the result is  2013-1   , 2013-2 etc.

I want the label  to display as follows   

2013-JAN    2013-FEB

pls help me to rewrite the above expression correctly

[#2]

Hi,

If your R_MONTH filed is numeric then try below expression,

='Premium ' & (Max(R_YEAR)) &'-'& (Date(DATE#(MAX(R_MONTH),'M'),'MMM') )