[AccessD] Access date problem

Haven't a clue, but you might want to check the time settings on that
machine to see if the timestamps are off by 12 hours.

Charlotte Foust

On Mon, Sep 5, 2011 at 2:12 PM, Doug Steele <dbdoug at gmail.com> wrote:

> Hi Charlotte:
> Changing all instances of the Weekday function to include vbSunday as the
> second parameter did fix the problem.  I'm still curious, however, why one
> computer in particular would have vbMonday set as the first day of the week
> contrary to the Access documentation.
>
> Doug
>
>
> On Mon, Sep 5, 2011 at 11:35 AM, Charlotte Foust
> <charlotte.foust at gmail.com>wrote:
>
> > It's set in vba using the Weekday function and specifying the optional
> > firstdayofweek argument.  If you just modify your code to include
> vbSunday,
> > you should get the desired result.  Have you tried that?
> >
> > Charlotte Foust
> >
> > On Mon, Sep 5, 2011 at 9:19 AM, Doug Steele <dbdoug at gmail.com> wrote:
> >
> > > 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
> > > --
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> > >
> > >
> > > Website: http://www.databaseadvisors.com
>
>
> > >
> > >
> > >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> > Website: http://www.databaseadvisors.com
>
>
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>