Forum Discussion
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...
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.
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.