[AccessD] Access date problem

Doug Steele dbdoug at gmail.com
Mon Sep 5 11:19:30 CDT 2011


Hello All:

I have some code which depends on the weekday number.  On all computers
except for one of my client's, it runs OK.  The computers are a mixed bag of
Access 2003, 2010 and Windows 7 and Vista.

On the 'bad' computer, everything is off by one day.  Debugging on this
computer gives '7' as the result of Weekday("9/4/2011") - a Sunday.
 According to Access help, the default for Sunday is 1.  I've checked the
Windows 7 Regional and Language settings on this computer and 'Sunday' is
set as the first day of the week.  So Access and Windows are different.

I can't find a setting in Access to change this, and nothing on the Web.
 But it must be some kind of configuration setup - does anyone have a
suggestion?

Thanks,
Doug



More information about the AccessD mailing list