Date relationships not working

[longishrope]

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 doesn't seem to work. I'm stuck.

[KHorseman]

The Calendar table in your screenshot appears to be blank.

[longishrope]

That's the problem. The Calendar table isn't actually blank. But when I try to make a relationship it appears to be.

[sdjensen]

@longishrope 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?

[longishrope]

@sdjensen

I get the same result as my initial post

[KHorseman · Accepted solution]

The two columns need to be the same data type. It looks like it's Date in one table and DateTime in the other.