Reset day 1..for a database to Monday

[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

 

[Guest]

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.

 

[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.










- Show quoted text -

...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 ..

 

[Guest]

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"))

 

[John W. Vinson]

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).

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]