Need Help

[paulwalker]

Hi Community,

I have one issue in Expression Label..

In my bar chart comparing Current month and Previous Month data.

in label i have used Max(Month) but it showing Number... I want to show Month name..

based on selection i want to change...

Thanks in advance..............

[settu_periasamy]

Try,

=MonthName(Max(Month))

[paulwalker]

Hi Settu,

Thanks for response...

it's showing jan 1900

[paulwalker]

Hi All,

=If(Max(Month)=12, 'Dec',

     If(Max(Month)=11, 'Nov',  and so on......

This expression works fine............

any other solution..????

[settu_periasamy]

Sorry,

Try this,

Month(Max(Month))

[PrashantSangle]

Hi,

if you have to different field for month and year then try

max(Month) &' '& max(Year)

or create a monthyear field in script level and use it in your front end.

Regards

[maxgro]

left(MonthName(Max(Month)),3)

date(Max(Month),'MMM')

[Anonymous]

Hi Paul ,

Check your default monthname settings .

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

Thanks

[#9]

Hi Paul,

Try like this way:

Date(Max(Month), 'MMM')

Ramya.

[paulwalker]

HI All,

Thanks for reply everyone..

In expression label i want to show Month name and previous month name

PFA,