Reset day 1..for a database to Monday

  • Thread starter Thread starter ramrod
  • Start date Start date
R

ramrod

Hi

I need to set day 1 for a datebase to Monday !


I have a table where day 1 is Monday, and all seems to be working
fine.. until some calulations by Access... assumes day1 Sunday !

Can some one tell me, is there a gobal setting, where I can set the
database to assume day on is Monday (... or where to alter the global
calculation and how).

Many thanks ...

Ramrod
 
In the date/time formats, the day of the week is represented by 1 to 7.


WEEKDAY function

Return_type

is a number: for Sunday = 1 through Saturday = 7, use 1; for Monday = 1
through Sunday = 7, use 2; for Monday = 0 through Sunday = 1, use 3.
 
In the date/time formats, the day of the week is represented by 1 to 7.

WEEKDAY function

Return_type

is a number: for Sunday = 1 through Saturday = 7, use 1; for Monday = 1
through Sunday = 7, use 2; for Monday = 0 through Sunday = 1, use 3.










- Show quoted text -
Click to expand...


...can you tell me where i should find/edit/place this WEEKDAY
Function ? I understand the principle .. no idea where to put it for
a global effect. Thank you ..
 
You haven't provided much information about your calculations. I won't
assume you are doing it in a query but it would be the following:

Expr1: Weekday([yourfield],2)
Expr2: (Format([yourfield],"ddd"))
 
Hi

I need to set day 1 for a datebase to Monday !


I have a table where day 1 is Monday, and all seems to be working
fine.. until some calulations by Access... assumes day1 Sunday !

Can some one tell me, is there a gobal setting, where I can set the
database to assume day on is Monday (... or where to alter the global
calculation and how).
Click to expand...

The Weekday (and all the other relevant date functions) have an optional
argument which specifies the day of the week. For example,

Weekday(Date(), vbMonday)

in VBA code will return 1 for Monday, 7 for Sunday. See the online help for
the function that you're using.

John W. Vinson [MVP]
 
Back
Top