Hi,
I am building a document which requires users to define the time horizon and periodicity requirements, upon which we collect data. This is done through two fields - Start Date and End Date. The period defined will be typically be a 5 year period but can be more or less.
Upon defining this period there is another column 'Time Period' which should automatically be populated with annual periods. For example:-
Start Date - 2/1/2013
End Date - 11/30/2017
Time Period - Feb 2013 - Dec 2013
- Jan 2014 - Dec 2014
- Jan 2015 - Dec 2015
- Jan 2016 - Dec 2016
- Jan 2017 - Nov 2017
I am at odds to figure this problem out. Any help on this is highly appreciated
I am building a document which requires users to define the time horizon and periodicity requirements, upon which we collect data. This is done through two fields - Start Date and End Date. The period defined will be typically be a 5 year period but can be more or less.
Upon defining this period there is another column 'Time Period' which should automatically be populated with annual periods. For example:-
Start Date - 2/1/2013
End Date - 11/30/2017
Time Period - Feb 2013 - Dec 2013
- Jan 2014 - Dec 2014
- Jan 2015 - Dec 2015
- Jan 2016 - Dec 2016
- Jan 2017 - Nov 2017
I am at odds to figure this problem out. Any help on this is highly appreciated