Search results

I'm trying to count the number of workdays in a month, excluding weekends and holidays as listed in a separate table. In order to do this I'm using the function developed by Arvin Meyer: Public Function WorkingDays2(StartDate As Date, EndDate As Date) As Integer...

It works! Thanks so much.

I changed the code to the following: DCount("*", "tbl_Holidays", "HolidayDate = #" & Format(12/12/2016, "mm/dd/yyyy") & "#") DCount("*", "tbl_Holidays", "HolidayDate = " & Format(12/12/2016, "\#mm/dd/yyyy\#")) It made no difference. Still doesn't work.

Hi All, I’m having some problems filtering for a date with DCount. My regional settings are set to European date format (dd/mm/yyyy). In my final code I'm using a variable for the date, but to simplify things I'm just putting an actual date in the examples below. If I look for the date number...

Oxicottin, love your work on the Attendance DB! I have a question which I'm hoping you'll be able to help me with. My date settings are mm/dd/yyyy. Your DB is configured to dd/mm/yyyy which means that all the dates from dd 1-12 are filed wrongly and the entries on the calendar remain invisible...