Forum Discussion
Solved
Working Days Between Two dates in two Tables
Hello Guys, I have two Tables, Table 1 contains an "Open Date" , Table 2 Contains "Escalated Date" I would like to calculate the workings days which have passed between the "Open Date" a...
Here is another file that is simplified with the table and column names matching your examples so it should be easier for you to follow. I have also included step-by-step instructions of what to do to integrate this with your script (text in green font shown in the snip below). Below is a snip from the Advanced Editor view of Table2. Essentially you will copy/paste into your query and then make a couple of edits.
Thank you so so much this has helped massivley, Apologies on the novice Questions
You are very welcome! We have all been there. 🙂