Canonical Date

[Anonymous]

I am working on an app where I have three different dates - Charges_Dt, Budget_Dt and Adj_Dt which need to be combined into one 'canonical date'. Also, the Prod_Adj table must be linked to the ChargesWRVU table. I tried doing that with this data model (attached), but it doesn't seem to be working. Any help or ideas would be appreciated. Thanks!

[devarasu07]

Hi,

have u tried to use multiple master calendar option ? this method should work for your case.

check this article

Canonical Date

[Anonymous]

Yes, I did and that's what this data model is based on, I created three different calendars - Budget, Charges and Prod_Adj Calendar.

[devarasu07]

Hi,

can you share your mock app? may be u can take a look on the attached app as welll (they have used multiple calendar method)