I have to create a record for every weekstart between two dates, So I borrowed this script
Load *, Week(Date) as Week;
LOAD Date(MinDate+IterNo()-1) as Date
While MinDate+IterNo()-1 <= MaxDate;
LOAD Min(startDate) as MinDate,
Max(endDate) as MaxDate
AutoGenerate 1;
But that gives a record for every day between two dates.
Similar to this I create a record for every month between to dates useing this script:
load *
addmonths(MonthStart(Inschrijvingen.datefrom),IterNo()-1 ) as used_month
Resident date_values
While (date_end)> AddMonths(MonthStart(datefrom),IterNo()-1);
But there is no such function as addweeks.
What do I miss.
