Forum Discussion

rdops's avatar
rdops
Helper III
6 years ago

Help comparing dates between tables

Hi there, I am hoping someone can help me with this. Have spent hours and hours looking through the solutions posted and cant figure out.   I have two different systems for people to enter timeshee...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi rdops ,

 

What's your expected result?

Not sure if i understand you correctly, but i used EXCEPT() function and below is the result.

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

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

  • rdops's avatar
    rdops
    Helper III
    6 years ago

    Thanks for your erply V-Jay. What I want is to know which dates are in system A but not in System B, which is exactly what you got there. Not sure why I cant make it work. Will try it again now using your except formula.

    Thanks again.

    Cheers 

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi rdops ,

       

      Click the New Table feature under Modeling then paste the formula to the input box, that should work.

       

      Best Regards,

      Jay

       

      Community Support Team _ Jay Wang

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

  • rdops's avatar
    rdops
    Helper III
    6 years ago

    Jay, tried yours but didnt work because the two systems are not as clean/simple as the two examples below.

    I have about 20 different fields on each table/system. Is just that I only need the missing date in system B.

    I used the formular you posted and got an error; I assume I need to tell the tool whych column on each table I want to compare.

    I tried the exceptx(filtered option and got nowhere.