DATEDIFF using working days

[Anonymous]

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 · Accepted solution]

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