Forum Discussion
Date Relationship not working
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.
gabilamarcks Check the datatypes in both the "Edit Queries" section as well as the model. Make sure they match. If that doesn't work, does the date value exist in both tables?
Indeed the data types were different when I went to "Edit Queries". I adjusted both for Date/Time in the queries and the models. Still doesnt work. I am sure there are matching data values in both tables.
gabilamarcks did you "Close and Apply" the change?
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.