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

[sujeetsingh]

Use this

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

[jjordaan]

Use

='Premium ' & (MAX(YEAR(R_YEAR))) &'-'& (MAX(MONTH(R_MONTH)))

[Anonymous]

Can you try ='Premium' & (YEAR(MAX(R_YEAR))) & '-'&(MONTHNAMES(MAX(R_MONTH))).

[MayilVahanan]

HI

Try like this

='Premium ' & (MAX(YEAR(Today()))) &'-'& (MONTH(Today()))

Gives result as "Premium 2014-Feb"

Edit:

='Premium ' & (MAX(YEAR(Today()))) &'-'& Upper(Month(Max(Today())))

Gives result as "Premium 2014-FEB"

[Sokkorn · Accepted solution]

Hi Upali,

Use this

='Premium ' & (Max(R_YEAR)) &'-'& Pick(Max(R_MONTH),'JAN','FEB','MAR','APR','MAY','JUN','JUL','AUG','SEP','OCT','NOV','DEC')

Regards,

Sokkorn

[amit_saini]

Hi Upali,

Try this:

Year(Datefield) & ' / ' & Month(Datefield)

Thanks,

[ashwanin]

='Premium ' & (MAX(YEAR(R_YEAR))) &'-'& (MAX(MONTH(R_MONTH)))

[sunilkumarqv]

Copy and past this in your script. Its working in my text box

='Premium' & (YEAR(MAX(R_YEAR))) & '-'&(month(MAX(R_YEAR)))

OR

='Premium' & (YEAR(MAX(Today()))) & '-'&(month(MAX(Today()-30)))  & '  '& 'Premium' &(YEAR(MAX(Today()))) & '-'&(month(MAX(Today())))

[#10]

Hi Upali,

Try to this

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

='Premium ' & (MAX(YEAR(Today()))) &'-'& Upper(Month(Max(Today())))

and jeroen also put right expression try to both

Regards,

DJ