MonthName(AddMonths...)

[#1]

Hello,

I have a problem with addmonth.

i write =monthname(AddMonths(AnnéeMois,-1)) but it's not working.

any help please

[sunny_talwar]

When you say its not working, can you elaborate what the issue is? Does it give you an error, or does it become null? What exactly is the issue?

On another note, have you made sure AnnéeMois is a date field and not text field formatted as date?

[MindaugasBacius]

If this works than the issues with the date formatting:

=MonthName(AddMonths(today(),-1))

Could you please let us know how your date field looks like and what kind of values do contain?

[#4]

Hi Sunny,

it become null

[sunny_talwar]

My guess is that AnnéeMois is not read as a date. Can you try this:

=MonthName(AddMonths(Date#(AnnéeMois, 'DateFieldFormatHere'), -1))

Where you will replace DateFieldFormatHere with the format that is associated with AnnéeMois

[#6]

it's not working

[MindaugasBacius]

Share with us how your AnnéeMois field looks like.

[#8]

I think the problem is qlikview not read AnnéeMois like a date but i dont know how and what i can to do for to change this

[#9]

AnnéeMois is like Juillet 2015

[bertinabel]

Hola Sami,

     ¿Ya probaste con la solución que te indicó Sunny T?

=MonthName(AddMonths(Date#('Jul 2015','MMM YYYY'),-1))

en u caso es reemplazar 'Jul 2015' por AnnéeMois

=MonthName(AddMonths(Date#(AnnéeMois,'MMMM YYYY'),-1))