Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You can also try this way:
=addmonths(Date#('$(vdate)','MMM-YYYY'),1)
Hi,
try
=addmonths($(vdate),1)
Regards,
Cesar
Thanks,it didn't work as well.Gosh i spent the whole day trying to figure this out.I am about to crash!!
Try this
=Addmonths(vdate,1)
Can you tell me how you stored the date in vdate variable?
MMM-YYYY
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
Hi,
You can also try this way:
=addmonths(Date#('$(vdate)','MMM-YYYY'),1)
Hi
This works but bring the date in 01/01/2000 format,i want it to be Jan-2000
thanks
Hi Cesar
It worked,
=date(addmonths(Date#('$(vdate)','MMM-YYYY'),1),'MMM-YYYY')
Thanks all for all your help.