CalcWorkDays for Canada (English)

  • Thread starter Thread starter Thing2
  • Start date Start date
T

Thing2

My regional settings are Canada(English) and the calcworkdays function
doesn't seem to work properly with them. Is there a way of coding the
function to recognize the Canada(English) settings all the time? This
converts nicely to my co-worker's machine, but when I re-access it, the dates
are wrong for me. My co-worker's machine is US settings. The AddWorkDays
works great.

Thanks,
 
Thanks to a combination of a bunch of your previous answers (Klaatu, DSteele,
ABrowne) we got it. We had to format the dtmStart/dtmEnd as international
format, otherwise one or the other of our machines wouldn't work for the 1st
12 days of the month.
CalcWorkDays = CalcWorkDays - DCount("*", "tbl_Holidays",
"[Holidays] between #" _
& Format(dtmStart, "yyyy\-mm\-dd") & "# And #" & Format(dtmEnd,
"yyyy\-mm\-dd") & "#")

works on both US & Cdn.

Thanks, guys - this forum is amazing.
 
Back
Top