Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Look at Canonical date concept: Canonical Date
Look at Canonical date concept: Canonical Date