Forum Discussion

FraChi's avatar
FraChi
Regular Visitor
6 years ago
Solved

Relationship Date/Time Column

Hello,

 

I am trying to make a relationship between two columns of different tables having Date/Time format with no success.

See screenshot below:

 

I tried cardinality Many to Many but the data are not plotted.

I want to use the StartDate in Table2 and the Ring in Table1 because Table2 contains the distinct value of StartDate.

 

Any idea how to make this work?

 

Thanks

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi FraChi ,

     

    These two columns can't find the corresponding value at all.

    For example, I have two tables like these.

    (Table2)

    (Table1)

    I got this when I create a relationship between the two tables:

    So you should create relationship between [Ring] column with [Ring[#]] column.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    Wait, you are trying to create a relationship between Start Date in Table1 and Ring # in Table 2?

    • FraChi's avatar
      FraChi
      Regular Visitor
      6 years ago

      I am trying to make a relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2.

      • FraChi's avatar
        FraChi
        Regular Visitor
        6 years ago

        Any idea why the relationship between StartDate of Table1 and Start Date [yyyy-mm-dd hh:mm:ss] of Table 2does not work?

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi FraChi ,

     

    "I want to use the StartDate in Table2 and the Ring in Table1 because Table2 contains the distinct value of StartDate."

    It doesn’t make sense to use these two columns to create a relationship.

    Maybe you can use [Ring] column in table1 and [Ring[#]] in table 2 to create a relationship or use [StartDate] in table1 and [Start Date[yyyy-mm-dd hh:mm:ss]] in table2 to create a relationship.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.