Table relationship with Dates not working

[bensasse]

Both formatted as Date in the table and Query Editor and it STILL will NOT create a relationship between the two that I can filter off of..... What am I missing here? It will filter one table but not the other.

[sevenhills · Accepted solution]

Just guessing

- Based on the screenshot, one is active many-to-many and other is inactive. You can test by making the other active (, automatically other will become inactive)

My 2 cents

- add one date table and then use it in the data model