Forum Discussion
Solved
Date comparison beetwen 2 tables
Hello, In my model I have 2 tables with purchase orders (from 2 different databases) and I need to compare Delivery dates. I think, it's more complicated because, each purchase order has mult...
Hi szczepaneq ,
Create a many to many relationship between two tables using [Purchase order]. But as you said if there's two rows in table1 and two rows in table2 and you don't have any other rows to identify the records, so there would be four rows to be shown.
Best Regards,
Jay
Hi szczepaneq ,
Create a many to many relationship between two tables using [Purchase order]. But as you said if there's two rows in table1 and two rows in table2 and you don't have any other rows to identify the records, so there would be four rows to be shown.
Best Regards,
Jay
I have created new column "PO line" (based on chronological date) and with relation 1:1 the comparison is possible (using DATEDIFF function). Thanks.