Page 1 of 1

Getting 12 months from any given time

Posted: Wed Jan 13, 2021 3:16 pm
by samiamsz
I have to write a process that basically gets a month from a user and copies data into a new book from that date and twelve months onward.

Im using a cellgets to get the month I need, But in the cellputN for the period, Im not sure how to do it.

Im assuming i need a variable that takes the user entered Month and adds the next 11 moths to it, But im not sure how to do this. I have worked on rolling months but it wouldnt work here

Re: Getting 12 months from any given time

Posted: Wed Jan 13, 2021 5:41 pm
by Ajay
1) Are you wanting the 12th month ? if so why don't you use an attribute on the elements which has the 12th month in it ?

or

2) Are you wanting the all the 12 months ? If so why not have a consolidation of the months which you can reference in an attribute from the selected first month ?

HTH
Ajay