I am trying to use addmonths in the variable that i have created.The below does not work:
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
You can also try this way:
This works but bring the date in 01/01/2000 format,i want it to be Jan-2000
Thanks all for all your help.
Retrieving data ...