Addmonths function in qlikview variable

[#1]

Hi

I am trying to use addmonths in the variable that i have created.The below does not work:

=addmonths($(vdate,1))

=$(addmonths(vdate,1))

Please assist.

[cesaraccardi]

Hi,

try

=addmonths($(vdate),1)

Regards,

Cesar

[#3]

Thanks,it didn't work as well.Gosh i spent the whole day trying to figure this out.I am about to crash!!

[CELAMBARASAN]

Try this

=Addmonths(vdate,1)

Can you tell me how you stored the date in vdate variable?

[#5]

MMM-YYYY

[MayilVahanan]

Hi

     Try like this

     if vdate -> Date(today(),'MMM-YYYY')

     Date(AddMonths(vdate,1),'MMM-YYYY')  , it gives AddMonths(vdate,1) -> 8/31/2012

     Hope it helps

[cesaraccardi · Accepted solution]

Hi,

You can also try this way:

=addmonths(Date#('$(vdate)','MMM-YYYY'),1)

[#8]

Hi

This works but bring the date in 01/01/2000 format,i want it to be Jan-2000

thanks

[#9]

Hi Cesar

It worked,

=date(addmonths(Date#('$(vdate)','MMM-YYYY'),1),'MMM-YYYY')

Thanks all for all your help.