how to create master calendar and map to the fields?

[gkcchowdary]

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

[Anil_Babu_Samineni]

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;

[juraj_misina]

Hi,

I think you need The Fastest Dynamic Calendar Script (Ever)

Best

Juraj