Doubt about format in year-month and adding a month

[#1]

Hi!

I have the field Year-Month For example 2014-Apr

I'd like to have Year-(Month+1) For example 2014-May

I tried a few options but they aren't working

What do you think?

Greetings

PD: I can't use for example addmonths(month,1) because i don't have date, i have year-month.

[Gysbert_Wassenaar]

I recommend creating a date field in the script: date(monthstart(date#(MyYearMonthFieldHere,'YYYY-MMM')),'YYYY-MMM'). Then you can use the addmonths function. The field values will still be displayed in Year-Monthname format.