Create Repetitive Table with Given Rules

[Anonymous]

Hello,

I have a table which represents scheduled tasks. What I want to do is create a table to show upcoming tasks.

Unittype express the repetition of task. 4 is monthly, 2 is daily etc.

Period means that repetition count for given unittype.

For 2nd row, I know the schedule of task. Run it every one {period} day {unittype} at 10.00 AM {hour and minute of startdate} starting from 3/23/2021 10.00 AM {startdate} 

And I should be able to limit the maximum date of my table due to performance issues. In this example, lets say maximum date is 3/28/2021. There will not be more row after that date.

ID	Upcoming Schedule
129297	3/24/2021 10.00 AM
129297	3/25/2021 10.00 AM
129297	3/26/2021 10.00 AM
129297	3/27/2021 10.00 AM
129297	3/28/2021 10.00 AM

How can I create this table with queries? Thanks for your answers.

[Anonymous · Accepted solution]

given the narrowness of your description, a more precise answer is difficult to give. But, if you are able to adapt the code, it might be enough for your purposes. Otherwise Load some example tables so they can be copied and explain well what's behind "etc"