Discussion board where members can get started with QlikView.
I am trying to use addmonths in the variable that i have created.The below does not work:
Go to Solution.
You can also try this way:
Thanks,it didn't work as well.Gosh i spent the whole day trying to figure this out.I am about to crash!!
Can you tell me how you stored the date in vdate variable?
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
This works but bring the date in 01/01/2000 format,i want it to be Jan-2000
Thanks all for all your help.