Master Calendar

[#1]

Hi

my table has multiple rows for each date.

and when I use the master calendar codes and when the tables are automatically connected by [Complete Date], not all of the rows are picking up the Master Calendar data. actually more rows are missing the fields from the Master Calendar. How do I fix this problem?

[swuehl · Accepted solution]

Have you checked that your dates are not in fact timestamps that may not match with your master calendar dates?

A timestamp can be formatted as date using Date(), but the underlying value is keeping the time.

Why don’t my dates work?

[#3]

Thank you! I aligned the format of dates in my fact table and calendar table and it works now!

Thanks!

[sunny_talwar]

David - I would advise you to close this thread by marking Stefan's response as the correct answer.