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.

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.