Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DATEDIFF using working days

Hi All,

I know there are a few posts about this already but I can't quite find exactly what I need, I've setup a data table shown below, then I have another table with 2 dates I want to work out the number of working days between, how do I use the date table to complete this please?

 
 

thanks

Tammy

 
 

  • judspud's avatar
    judspud
    6 years ago

    Hi Anonymous 

     

    Without using the DATEDIFF function you could add a Working Day Flag to the date table. i.e. Mon to Fri =1, Sat and Sun = 0.

     

    Then use the sum function on the Working Day Flag field where the date is less than x and greater than y.

     

    Hope this helps

     

    George

1 Reply

  • judspud's avatar
    judspud
    Icon for Solution Supplier rankSolution Supplier
    6 years ago

    Hi Anonymous 

     

    Without using the DATEDIFF function you could add a Working Day Flag to the date table. i.e. Mon to Fri =1, Sat and Sun = 0.

     

    Then use the sum function on the Working Day Flag field where the date is less than x and greater than y.

     

    Hope this helps

     

    George