diff
1 Topic
Subtract the 3 dates from different tables
I have Table2[dateBefore], Table1[dateBegin] and Table1[dateEnd]. So, I need to subtract the 3 dates, so I can have the result in DAYS: so something like Table2[dateBefore] - Table1[dateEnd] - Table1[dateBegin] So, I create a new coloumn call DatesDiff = DATEDIFF(Table2[dateBefore], Table1[dateBegin], DAY) + DATEDIFF(Table2[dateBefore], Table1[dateEnd], DAY) But the new coloumn call DatesDiff is create in Table1, so I can have acces to Table2[dateBefore]. How can I do if I want to subtract column from differents tables? I need to have an ID common to the 2 tables to do that? Can I do that using join? Please, give complete answer.Solved710Views0likes2Comments