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.