Getting Overflow Error 6 in CountBusinessDays function on 1

[JimWho]

I am using a function which counts business days and takes holidays into consideration. I am using Access 2000 in Canada if that means anything re dates.

When I get the error message I select debug and it takes me to this line "dteTemp = dteTemp +1" when I point my mouse pointer over it this is displayed "dteTemp = 9999/12/31 10:14:29 AM"

dteTemp is defined in the DIM statement as a Date.

I am a beginner so I am just learning this stuff now, but I am at my wits end as to how to fix. Can you help?

 

[jiqjaq]

Something is either wrong with your function or one of the values it uses. You're getting the error because you are attempting to add 1 day to the 31 Dec 9999. The system can't handle any dates beyond the year 9999.

 

[MichaelRed]

see faq181-261, but be aware that all dates used in Ms. A. queries must be in U.S. date format -regardless of the locale settings. It APPEARS that the date format in your procedure is 'yyyy/mm/dd' - which is a bit off from the expected/requirement (mm/dd/yy or mm/dd/yyyy).

W/o recourse to the complete function you are using, and at least a sample of the arg(s), additional 'review' doesn't seem to be useful.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places