Hi All
I want VbA code to find a date 1 less than todays date taking into account weekends/Bank Holidays.
Any help will be much appreciated.
Thanks
Hi All
I want VbA code to find a date 1 less than todays date taking into account weekends/Bank Holidays.
Any help will be much appreciated.
Thanks
I have set up the table for bank holidays. please see attached.
I am using the following code:
But I also need to check bank holidays and Weekends too in the code. Any help will be much appreciated.strsql = "select count(*) from tblmaster where Date1 = #" & Format(DateAdd("d", -1, CDate(Date)), "mm/dd/yyyy") & "# and Printuser is null" rs.Open strsql, cn, adOpenKeyset, adLockOptimistic j = rs.Fields(0).value
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks