Hi,
I have a table of activities ("I_ID") starting on various dates ("Period from").
| I_ID |
Period From |
| 120400 |
2021-01-26 |
| 120746 |
2021-02-16 |
| 118469 |
2020-03-16 |
| 118848 |
2020-05-24 |
| 119282 |
2020-07-22 |
| 119494 |
2020-10-07 |
| 120109 |
2020-11-10 |
| etc. |
etc. |
In the script, based on the "Period From" dates, I want to auto generate custom calendar periods (one year) for each start date. E.g. CAL_01_26 (26/1 to 25/1), CAL_02_16 (16/2 to 15/2), etc.
I have tried to declare the calendar fields in a loop but I'm getting all sorts of mysterious errors 😞 Perhaps this is the wrong approach? Help on this issue would be highly appreciated.
Best regards//Peter
