Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dates
- Thread starter RGeoffb
- Start date
Hi!
I think every time you use a function returning/using/involving weekdays, cause sunday is default.
For instance the weekday function:
[tt]=weekday(Date(),2)[/tt] - as control source
[tt]intDay=weekday(Date(),vbMonday)[/tt] - in VBA code
Last argument is "firstdayofweek" which then must be set each time you use it. The vbMonday constant might be used in code, 2 (same as vbMonday constant) might be used in control source.
You could also try using 0 (vbUseSystem) to make it use the regional settings, but that might still provide some anomalities.
HTH Roy-Vidar
I think every time you use a function returning/using/involving weekdays, cause sunday is default.
For instance the weekday function:
[tt]=weekday(Date(),2)[/tt] - as control source
[tt]intDay=weekday(Date(),vbMonday)[/tt] - in VBA code
Last argument is "firstdayofweek" which then must be set each time you use it. The vbMonday constant might be used in code, 2 (same as vbMonday constant) might be used in control source.
You could also try using 0 (vbUseSystem) to make it use the regional settings, but that might still provide some anomalities.
HTH Roy-Vidar
- Status
Similar threads
