Working days - beginner (1 Viewer)

Hi all

Hoping someone can help as I'm struggling!

I am doing a query which includes a date criteria (ie Between 01/11/2019 and 01/12/2019).

The problem is, in this date range (or any that the user will select), it needs to exclude weekends etc.

I understand there is no access function to use only working days, you have to use vba script? I have seen the scripts you can use via google searches but I cannot work out how to tailor these for my purposes OR how to apply these in access to make it work with my queries. I don't know where to start!

Any help will be massively appreciated!

thanks

cmc,

I can't remember how back my FAQs and stuff were written, but look at the module code behind "_MiscFunctions" in the attached DB. The functions EDateDiff() and EDateDiffBus() might help you. In addition, I think there is also an example of what you're trying to do in my github repo here:

https://github.com/ajetrumpet102345/coding-examples

Hi. I don't understand, are you saying your records have weekends in them, but you don't want to see them in the query result?

How do intend to select the range? Via a combo box, a text box or using query parameters?


Combos are best for providing a relatively small set of selections and forcing the user to select one. Generate the combo's value list by looping through a range of dates and excluding the weekends using the Weekday function to filter out Saturdays and Sundays.


A text box formatted as a date will provide a calendar for the user to select from. In the Before_update event you could check if a valid date was entered.


In specifying " it needs to exclude weekends etc.", what does "etc" mean?