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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Calendar Week Start Default

Status
Not open for further replies.

TripperTim

Technical User
May 23, 2004
6
US
Can someone let me know how to get Access to view Monday as the start of a calendar week (european calendar) instead of Sunday (american calendar)? I know in Excel it is a simple parameter in the formula, but this is my first try in Access.
 
Take a look at the following functions:
Function WeekdayName(Weekday As Long, [Abbreviate As Boolean = Faux], [FirstDayOfWeek As VbDayOfWeek = vbUseSystemDayOfWeek]) As String
Function Weekday(Date, [FirstDayOfWeek As VbDayOfWeek = vbSunday])


Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top