Forum Discussion
Solved
Date Relationship not working
Hi all, I have a table wich contains all the engagements and associated Create Date. I want to create visuals that show engagements grouped by FiscalYear. To do that I created another table havin...
Yes did. I got a solution for it. It was a problem of not matching data type. But I had to create a calculated column having data type as "Date" from the original "Data/Time" column, for some reason I was getting an error in all rows just chaging the data type in the original column, so this extra column was needed. After creating this new column I updated the relantioship between the two and it works now. Thanks much.
Almost certainly the problem is your CreatedDate also has a time. Even if not "displayed" that way. You need to strip those off.