Master calendar using two dates in two tables?

Wed, 16 Mar 2016 15:13:15 GMT

Hi all,

Table1:

Material PaidDate PaidAmount BU customer

Table2:

Supplier SpendDate SpendAmount

Table3:

Material Supplier

I have these three tables to use.

I have to make association between two these tables based on Date in first 2 tables and then with third table.

The problem I am facing here is how to use the two date columns (PaidDate and SpendDate) in master calendar .

(Spend is in one month and paid is in different month)

How can I achieve this ?

Thanks and regards

Prashanth.

Re: Master calendar using two dates in two tables?

sunny_talwar — Wed, 16 Mar 2016 15:14:00 GMT

Look at Canonical Calendar -> Canonical Date

Wed, 16 Mar 2016 17:18:39 GMT

Thanks for the reply sunny.