Exclude Weekend from DateDiff function

[falcondeer]

Hi all,

I need help please,

I have a physiotherapy clinic where the clerk enters the referral date and the phsyio appointment date to calcualte how many days the patient is waiting as a performance indicator.

I created a query that calculates the days between all dates in the DB and it is doing it fine, the problem is that I want to exclude all saturdays and Sundays from the calculations.

Second, is it possible just to do it in the SQL View of the query.

I appreciate the help.

 

[Minty]

Have a read up here https://access-programmers.co.uk/forums/showthread.php?t=40415&highlight=excluding+weekends

 

[falcondeer]

Have a read up here https://access-programmers.co.uk/forums/showthread.php?t=40415&highlight=excluding+weekends

Hi Minty, I could not download the zipped date file.

 

[bob fitz]

Take a look at the attached db. Look at "Business Dates"