Where holiday dates are stored when calculating workdays on this DB (1 Viewer)

Mackbear

Registered User.
Local time
Today, 16:40
Joined
Apr 2, 2019
Messages
168
Hi, good day! Hope you're all doing fine, reaching out again for help. I found this Db (See attached) on this thread https://access-programmers.co.uk/forums/showthread.php?t=240120.

My question is, where does it get the holidays? Is there a table or somewhere where the holiday dates are stored? I apologize if I am missing this, just a beginner on this. Thanks!
 

Attachments

  • db3.mdb
    328 KB · Views: 47

theDBguy

I’m here to help
Staff member
Local time
Today, 14:40
Joined
Oct 29, 2018
Messages
21,358
Hi. The code gets the Holiday information from an array you pass to the function. Here's a quote from the comments in the code.
' Example:
' dhAddWorkDaysA(10, #2/9/2000#, Array(#2/16/2000#, #2/17/2000#))
' returns #2/25/2000#, which is the date 10 work days
' after 2/9/2000, if you treat 2/16 and 2/17 as holidays
' (just made-up holidays, for example purposes only).
 

Mackbear

Registered User.
Local time
Today, 16:40
Joined
Apr 2, 2019
Messages
168
Hi. The code gets the Holiday information from an array you pass to the function. Here's a quote from the comments in the code.


If I understand correctly, the holidays are the dates inside the Array ()?
 

Mackbear

Registered User.
Local time
Today, 16:40
Joined
Apr 2, 2019
Messages
168
How can I store the Holiday dates in a table instead of having in within the vba code?
 

Mackbear

Registered User.
Local time
Today, 16:40
Joined
Apr 2, 2019
Messages
168
Thanks I will try those out as soon as I get back on this project that needs it, for now I am working on a different one.... thanks a lot!
 

theDBguy

I’m here to help
Staff member
Local time
Today, 14:40
Joined
Oct 29, 2018
Messages
21,358
Thanks I will try those out as soon as I get back on this project that needs it, for now I am working on a different one.... thanks a lot!

Okay. Good luck! Let us know how it goes...
 

Users who are viewing this thread

Top Bottom