Date Table Relationship Issue?

[pe2950]

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... 

[Anonymous]

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.

[HotChilli]

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