Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
First i need to create master calendar.
i have 3 tables with date fields and 3 dates fields different dates available.so how map the master calendar into this dates fields.
Thanks
daisy
Perhaps this?
Table:
Load Date1 as DateField, 'Date1' as Flag From T1;
Concatenate
Load Date2 as DateField, 'Date2' as Flag From T2;
Concatenate
Load Date3 as DateField, 'Date3' as Flag From T3;
Calendar:
Load DateField, Week(DateField) as Week, ....;
Load Date(MinDate + IterNo() - 1) as DateField
While Date(MinDate + IterNo() - 1) <= MaxDate;
Load Min(DateField) as MinDate,
Max(DateField) as MaxDate
Resident Table;