Hi all
In my workflow the period is determined by the start and end date. The workflow for the previous period runs couple of days after the new period as has started. This means in some cases, by the time I run the workflow for period 008 there is already data for period 009 in the system.
I want the logic that will only retain the data for the completed period.
For example: on the 9th of June I will be running for Period 008. I do not want period 009 data to show (I am currently filtering manually every month, I want to automate this process).
Start Date | End Date | Period | Workflow run date |
2021-10-06 | 2021-11-05 | 001 | 09-11-2021 |
2021-11-05 | 2021-12-06 | 002 | 08-12-2021 |
2021-12-06 | 2022-01-07 | 003 | 11-01-2022 |
2022-01-07 | 2022-02-04 | 004 | 08-02-2022 |
2022-02-04 | 2022-03-04 | 005 | 08-03-2022 |
2022-03-04 | 2022-04-06 | 006 | 08-04-2022 |
2022-04-06 | 2022-05-05 | 007 | 08-04-2022 |
2022-05-05 | 2022-06-07 | 008 | 09-05-2022 |
2022-06-07 | 2022-07-06 | 009 | 09-06-2022 |
2022-07-06 | 2022-08-04 | 010 | 08-07-2022 |
2022-08-04 | 2022-09-06 | 011 | 08-08-2022 |
2022-09-06 | | 012 | 08-09-2022 |
