Count the holidays between dates

[dhen21dx]

I have difficulty in building function for counting the holidays between dates, i used dcount however when converting it to function, not lucky as to have right result. Please help

 

[theDBguy]

Hi. Are you counting the holidays from a Holidays table?

 

[MajP]

dates need to be formatted as #mm/dd/yyyy# regardless of region. So probably something like

dcount("*","someQuery", "HolidayDate BETWEEN #" & format(me.startDate,"mm/dd/yyyy") & " AND #" & format(me.enddate,"mm/dd/yyyy") & "#")

 

[dhen21dx]

Hello Yes, counting the holiday from the table between 2 dates. I just want to have function to count that and called in query however didnt success yet. Yes i have that formula, however i want to have it in function.

 

[GinaWhipp]

Hmm, then for the Function you can Dim the Start Date and the End Date, add your DCount() and then Call it via...

fYourFunctionName(Me.txtStartDate, Me.txtEndDate)

You could just post what you have for us to take a look.