Forum Discussion
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...
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
judspud
Solution Supplier
Solution SupplierHi 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