Forum Discussion

longishrope's avatar
longishrope
New Member
9 years ago
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 doesn't seem to work. I'm stuck.

 

  • Anonymous's avatar
    Anonymous
    9 years ago

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

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    The Calendar table in your screenshot appears to be blank.

    • longishrope's avatar
      longishrope
      New Member

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

      • sdjensen's avatar
        sdjensen
        Icon for Solution Sage rankSolution Sage

        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?