How to get month name in expression label

[michael_maeuser]

Hi,

if i don´t select a month or year i want my expression to be labeled as previous month and current year (May 2012). if i select now may, it should be labeled as April 2012. I tried the following expression, but the else statement isn´t working:

='Umsatz ' &

if(GetSelectedCount(Month)=0, Monthname(Today()-31), only(Month)-1 and only(Year)-1)

Any ideas?

[MayilVahanan]

Hi,

     Try this,

          ='Umsatz ' & MonthName(MonthStart(Max(Date),-1))

          Where Date is the field from where you generate the year and month field.

     Hope it helps,

     R.Mayil Vahanan

[chematos]

Another way:

='Umsatz ' & MonthName(AddMonths(Today(),-1))

[#4]

Hi

Monthname(addmonth(today(),-1)) will work.

Thank you

Meher

[michael_maeuser]

Sorry no of those answers work correctly.

with today(), it´s not flexible anymore. again, it´s about the lable not the calculation expression. and if i select nothing, the result must currently be: May 2012. if i select e.g. may 2012, it must be april 2012.

if i select november 2011 it must show october 2011. always one month backwards. thanks for helping!

[chematos]

= if(GetSelectedCount(Year)=1 or if(GetSelectedCount(Month)=1,'Umsatz ' & MonthName(AddMonths(Today(),-1)),

'Umsatz ' & MonthName(Today()))