Forum Discussion

gabilamarcks's avatar
gabilamarcks
Regular Visitor
9 years ago
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...
Need Help
  • gabilamarcks's avatar
    gabilamarcks
    9 years ago

    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's avatar
gabilamarcks
Regular Visitor
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

gabilamarcks did you "Close and Apply" the change?

  • gabilamarcks's avatar
    gabilamarcks
    Regular Visitor
    9 years ago

    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.