Forum Discussion

DanielHolland's avatar
DanielHolland
Frequent Visitor
4 years ago
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...
Need Help
Tips and Tricks
  • jennratten's avatar
    jennratten
    4 years ago

    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.

     

     

jennratten's avatar
jennratten
Super User
4 years ago

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.

 

 

DanielHolland's avatar
DanielHolland
Frequent Visitor
4 years ago

Thank you so so much this has helped massivley, Apologies on the novice Questions

  • jennratten's avatar
    jennratten
    Super User
    4 years ago

    You are very welcome!  We have all been there.  🙂