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 th...
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.

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.