Forum Discussion
Date Table Relationship Issue?
I'm having some issue with a DateKey table relationship to a table of records with a create_date column.
I've removed everything else from the model that could have been causing an issue, and still stumped:
- DateKey table with key: Date
- confFSLeads table with column: created_at
- Ive verified the created_at is set to Date
- Relationship DateKey:Date (1) to confFSLeads:created_at(*); bidrectional filter (single does not matter)
When I create a simple visual table to spit out some and filter last 360 dates from DateKey, and count of created_at, I should get records...
2 Replies
How was the date table created?
The best test with these issues is to put both date columns in a table (no other filtering) and see if they match up.
If they don't, check for type mismatch, uk/us mismatch
Hi pe2950 ,
Please make sure both columns are type Date in the query editor (one might be DateTime).Please check if the date columns in a table without filters normally . The data types should match.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
