Date Relationship Sometimes Working

[mariah-pg]

Hello, I have a date table. (see image 1) I have 4 other tables and 4 corresponding relationships to the date table's "date" column. 2 of the relationships work, but 2 of them do not. All of the columns across the 5 tables have 'date' as their datatype. The structure of the date columns is YYYY-MM-DD. In Image 2, you can see that the table at the bottom is correctly showing the relationship with the date table. At the top of Image 2, you can see that data_date (from a different table) is not correctly joining with date from the date table. Image 3 shows the data type of affidavit_date from table 1, Image 4 shows how that affidavit_date column appears in SQL Server (this one is correctly showing the relationship). Image 5 shows the data type of data_date and Image 6 shows how that column appears in SQL Server (data_date and date do not correctly show their relationship).

The date table goes through mid 2022, so dates in the date table shouldn't be an issue.

Please let me know if any additional information would be helpful.

Image 1

Image 2

Image 3

Image 4

Image 5

Image 6

[mwegener]

Hi @mariah-pg ,

can you post a screenshot of the relationships in the model view?

[mariah-pg]

Hi @mwegener , Sure!

I'm not sure why, but I reloaded one of the tables (Table 2) that wasn't working and now it's working. 

In the image, the pink box is the date table. Tables 1,2,4,5, and 6 (all except table 3) connect properly. I can try to reload the data in table 3 and see if the issue gets fixed.