Excluding weekends and bank holidays

thedeadzeds · Oct 14, 2015

Hi Guys,

Is there a way of auto populating a date based on another date whilst excluding weekends and bank holidays?

So with regards to the attached database, can date due in frm_1 show 1 WORKING day ahead of the date input (eg date input is 14/10/15 so date due should show 15/10/15). This obviously gets tricky on a Friday (or bank holidays) as I don’t want the date to then show a Saturday for example?

Hope this makes sense?

Regards

plog · Oct 14, 2015

Yes, Microsoft has an article that describes this:

https://msdn.microsoft.com/en-us/library/dd327646(v=office.12).aspx?f=255&MSPPError=-2147217396

arnelgp · Oct 14, 2015

here try a made another table tblHoliday, you should fill this table with actual holidays in your area.

arnelgp · Oct 31, 2015

then don't use the constant variable

Dim strDateToIgnore as string
Select Case B_date Case 1 strDateToIgnore = "Fri/Sat" Case 2 strDateToIgnore = "Fri/Sat/mon/wed" End Select

arnelgp · Oct 31, 2015

from where are you calling this function. its supposed to skip those dates, and in your case statement.

arnelgp · Oct 31, 2015

is it possible for you to upload your db?

arnelgp · Oct 31, 2015

here try this:

Excluding weekends and bank holidays

thedeadzeds

Registered User.

Attachments

plog

Banishment Pending

arnelgp

..forever waiting... waiting for jellybean!

Attachments

arnelgp

..forever waiting... waiting for jellybean!

arnelgp

..forever waiting... waiting for jellybean!

arnelgp

..forever waiting... waiting for jellybean!

arnelgp

..forever waiting... waiting for jellybean!

Attachments

Similar threads

Users who are viewing this thread