Temp:Load Date(Date#(Date,'DD-MM-YYYY')) as Date Inline
[
Date
01-02-2014
28-04-2015
];
MinMaxDate:
Load Min(Date) as MinDate, Max(Date) as MaxDate Resident Temp;
Drop Table Temp;
Let vMinDate = Num(Peek('MinDate',0,'MinMaxDate'));
Let vMaxDate = Num(Peek('MaxDate',0,'MinMaxDate'));
Drop Table MinMaxDate;
Final:
Load Date($(vMinDate) + IterNo() - 1) as Date
AutoGenerate 1
While $(vMinDate) + IterNo() - 1 <= $(vMaxDate);
