Exclude Fridays and Saturdays from Datediff query in MS Access (1 Viewer)

Alhakeem1977

Registered User.
Local time
Today, 19:32
Joined
Jun 24, 2017
Messages
308
Hi,

I have got a table [tblFileLog] for a Log file system to manage the physical file movement between departments that contains the [Account number], [SentDate], [ReceivedDate] and [other columns].

My aim is how to exclude Weekends (Fridays and Saturdays) from a Datediff query between [SentDate] and [ReceivedDate] to return the number of business days?

Thanks a lot in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk
 

June7

AWF VIP
Local time
Today, 08:32
Joined
Mar 9, 2014
Messages
5,423
Will need a VBA custom function to count business days to exclude weekends and holidays. This is a common topic. Search forum or google to find examples.
 

plog

Banishment Pending
Local time
Today, 11:32
Joined
May 11, 2011
Messages
11,611
This site has a "Similar Threads" function that analyzes the initial post and suggests threads that cover the same topic.

Scroll to the bottom of the page to see the recommendations for your issue
||
||
||
\/
 

Users who are viewing this thread

Top Bottom