Variable Creation

[upaliwije]

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

[sunny_talwar · Accepted solution]

Try this for the 2nd variable

Let v2 = Date(AddMonths(Date#('$(v1)', 'MMM-YYYY'),1), 'MMM-YYYY'); 

[upaliwije]

Thanks Sunny for your prompt  reply.

I could get your advice after a some time