If date is Holiday then go back to prior BD

  • Thread starter Thread starter The Joker via AccessMonster.com
  • Start date Start date
T

The Joker via AccessMonster.com

Hello all,

I have what I think would be pretty easy issue to fix but I'm just brain dead
today I guess. I have a function which produces a date. All I need is to
see if that day is a holday. I have a table that has Holidays.. tblHolidays
containing 2 columns HolidayName and HolidayDt. I think I need some form of
a DLookup to see if the day is in the table and if so go back to the previous
business day. Anyone have some quick code that can achieve this? Thanks!
 
If Not IsNull("[HolidayDt]", "tblHolidays", "[HolidayDt] = #" & SomeDate
& "#" Then
'Go Back a day"
End If
 
Perfect!! Thank you very much, I really appreciate it!
If Not IsNull("[HolidayDt]", "tblHolidays", "[HolidayDt] = #" & SomeDate
& "#" Then
'Go Back a day"
End If
Hello all,
Click to expand...
[quoted text clipped - 4 lines]
a DLookup to see if the day is in the table and if so go back to the previous
business day. Anyone have some quick code that can achieve this? Thanks!
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Holiday - Error 4
DateDiff Working Days only not including holidays code problem 1
Excluding weekend and holidays 4
3 work days prior to 18th 2
calculating Holiday dates for multiple countries 12
Holiday Dates 1
The Tueday prior to a holiday... 8
Previous Business Day 2

Back
Top