Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Friends
I have created two variable as follows
Let v1=Date(Makedate(2017,12,01),'MMM-YYYY'); out put = Dec-2017
Let v2=Date(addmonths(Makedate($(v1)),1),'MMM-YYYY'); No out put Expected output =Jan-2018
In my 2nd variable I do not get any out put. But my expected output is Jan-2018. Pls help me to get it correct
Try this for the 2nd variable
Let v2 = Date(AddMonths(Date#('$(v1)', 'MMM-YYYY'),1), 'MMM-YYYY');
Try this for the 2nd variable
Let v2 = Date(AddMonths(Date#('$(v1)', 'MMM-YYYY'),1), 'MMM-YYYY');
Thanks Sunny for your prompt reply.
I could get your advice after a some time