topic Re: create calendar with for loop in App Development

create calendar with for loop

151562 — Wed, 07 Jun 2023 12:04:07 GMT

hello
I have a contract table that has a start and end date.
I need to generate a calendar between the smallest start date and the largest end date of a table.
Then make a for loop where I get each contract and its start/end dates, and from my calendar get the dates that are between them.
How can I do this?

Re: create calendar with for loop

marcus_sommer — Thu, 08 Jun 2023 11:38:20 GMT

You may use an internal while-loop to get each date between start and end and which is then associated with the master-calendar, for example:

t: load contract, start, end, date(start + iterno() - 1) as date
from source while start + iterno() - 1 <= end;