Field Name Confusing in Business Days Function.

[Jerry Maiapu]

Ok, I found a function that calculates/count business days excluding Weekends and holidays on the net.

My country's Holiday dates are in a table tblHolidays with fields. HolidayID,HolidayDate,HolidayName.
The Function:

Public Function WorkingDays(StartDate As Date, EndDate As Date) As Integer
'-- Return the number of WorkingDays between StartDate and EndDate
On Error GoTo err_workingDays
 
Dim intCount As Integer
 
If IsDate(StartDate) And IsDate(EndDate) Then
   If EndDate >= StartDate Then
 
      intCount = 0
      Do While StartDate < EndDate
         StartDate = StartDate + 1
 
            If Weekday(StartDate, vbMonday) <= 5 And _
            IsNull(DLookup("[Holiday]", "tblHolidays", _
            "[HolDate] = " & Format(StartDate, "\#mm\/dd\/yyyy\#;;;\N\u\l\l"))) Then
 
            intCount = intCount + 1
         End If
      Loop
      WorkingDays = intCount
   Else
      WorkingDays = -1  '-- To show an error
   End If
Else
   WorkingDays = -1  '-- To show an error
End If
 
exit_workingDays:
   Exit Function
 
err_workingDays:
   MsgBox "Error No:    " & Err.Number & vbCr & _
   "Description: " & Err.Description
   Resume exit_workingDays
 
End Function

Now I need to replace the field name Holiday in code line#15 with my table's field names. I know for sure that I should replace[b]HolDate [/B with HolidayDate but for Holiday I am quite confused would it be HolidayDate or HolidayID.
Can someone figure this out? Or is it another field that I need to create? I know this is simple for some people but please help.

Thanks

[RuralGuy]

Two changes:

If Weekday(StartDate, vbMonday) <= 5 And _ 
   IsNull(DLookup("[HolidayDate]", "tblHolidays", _ 
            "[HolidayDate] = " & Format(StartDate, "\#mm\/dd\/yyyy\#;;;\N\u\l\l"))) Then

[NeoPa]

I doubt it matters very much Jerry in fact. As it's only being tested for Null anyway, it's not the field that's important, but whether or not the record exists. If the record exists I doubt either field would contain a Null (which is the only thing that might confuse the issue).

PS. Please be careful with your titles. Field & Filed have thoroughly different meanings.

[Jerry Maiapu]

Thanks for the replies ..Now I can figure out how easy it was after your posts.

[RuralGuy]

Glad we could help.

[Jerry Maiapu]

Neo, Thanks for choosing my best answer..My internet suddenly dropped after the reply so I could not choose the BAnswer.

Cheers

[NeoPa]

I think possibly you tried and it worked, even though you weren't able to see it. I certainly didn't select it, though I would have been happy to do it for you if you'd asked me to for any reason.

[Jerry Maiapu]

@NeoPa
Wow, my fault maybe I did,,you're correct. You figure out things quickly so I thought you did.

In my side of the world we have a inconsistent zig zag type network here that drops and picks up quite too often so sometimes I do not have the time to really go through things thoroughly.. You know it is typical of developing nations..

But thanks again for most of the assistance anyway,

Best regards

Jerry