Forum Discussion
Solved
Date relationships not working
I have a table that contains Date values, I have also generated a separate Calendar table to make reporting better but I cant seem to join the two tables. I've tried different date formats but it...
The two columns need to be the same data type. It looks like it's Date in one table and DateTime in the other.
sdjensen
Solution Sage
Solution Sagelongishrope what happens if you go to the relationships tab and just create the relationsship by draggin Date from your fact table to the Date field in your Calendar table?
The two columns need to be the same data type. It looks like it's Date in one table and DateTime in the other.