Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have following dates :
Date |
---|
01-02-2014 |
28-04-2015 |
I want the field with all the dates between above two dates.
Kindly Help.
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);
check the master calendar