Hi,
I have a requirement to generate all the months (not just the month difference) between two dates from a list of records.
For example: My data would look like:
| Site | Start Date | End Date |
| A | 3/21/2014 | 6/25/2014 |
| B | 6/21/2014 | 8/30/2014 |
| C | 9/12/2014 | 2/3/2015 |
And my result should look like:
| A | Mar-14 |
| A | Apr-14 |
| A | May-14 |
| A | Jun-14 |
| B | Jun-14 |
| B | Jul-14 |
| B | Aug-14 |
| C | Sep-14 |
| C | Oct-14 |
| C | Nov-14 |
| C | Dec-14 |
| C | Jan-15 |
| C | Feb-15 |
Any help would be greatly appreciated.
Thanks,
Malai
