How can I do a Master Calender for multiple date fields in a single original table?

[jblomqvist]

Hi all,

How can I do a Master Calender for multiple date fields in a single original table?

Example:

TableA:

OrderID,

ItemNo

Quantity

OrderDate,

Value,

DueDate,

Discount

From TableA

The above table has two date fields OrderDate and DueDate.

I assume doing two Master Calenders, one for each date field would not be a great solution.

Are there any better alternatives?

[sunny_talwar · Accepted solution]

Look at Canonical date concept: Canonical Date