topic Re: Addmonths function in qlikview variable in QlikView

Addmonths function in qlikview variable

Tue, 31 Jul 2012 13:20:41 GMT

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 — Tue, 31 Jul 2012 13:23:50 GMT

Hi,

try

=addmonths($(vdate),1)

Regards,

Cesar

Tue, 31 Jul 2012 13:51:41 GMT

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

CELAMBARASAN — Tue, 31 Jul 2012 14:11:24 GMT

Try this

=Addmonths(vdate,1)

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

Tue, 31 Jul 2012 14:14:03 GMT

MMM-YYYY

MayilVahanan — Tue, 31 Jul 2012 14:26:18 GMT

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 — Tue, 31 Jul 2012 14:46:57 GMT

Hi,

You can also try this way:

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

Tue, 31 Jul 2012 15:21:30 GMT

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

thanks

Tue, 31 Jul 2012 15:39:39 GMT

Hi Cesar

It worked,

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

Thanks all for all your help.