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.
